Snowpro Associate Platform Exam Questions & Answers

All 23 questions

1. Q1 Which of the following is true about Snowflake's "auto-scale" feature for multi-clustered warehouses? (Choose any 2 options)
2. Q2 When loading data into a table using the COPY INTO command, what is the default error-handling setting?
3. Q3 What is created in the Cloud Services layer of the Snowflake architecture?
4. Q4 What is the function of the SKIP_HEADER file format option when loading CSV data?
5. Q5 What is the purpose of the ACCOUNTADMIN role in Snowflake? (Choose any 2 options)
6. Q6 How can you search for listings on Snowflake Marketplace? (Choose any 2 options)
7. Q7 What SQL command will return a list of all files in a stage?
8. Q8 What types of worksheets can be created in Snowsight? (Select TWO).
9. Q9 Which package is needed for Python worksheet?
10. Q10 What syntax will enable the use of a Python string variable named `myvar` in a SQL cell within a Snowflake Notebook?
11. Q11 When designing a new Snowflake solution, what is a key benefit of using `Zero-Copy Cloning` for development and testing environments?
12. Q12 What is a Reader Account" in the context of Snowflake Data Sharing?"
13. Q13 How do you specify a custom delimiter for a CSV file when using COPY INTO <TABLE>
14. Q14 What information can be accessed using the Snowsight Monitoring tab?
15. Q15 Which command will create a named internal stage?
16. Q16 What is the purpose of the USE SCHEMA command in Snowflake?
17. Q17 I have SELECT access on Table, still I cant read the data from the table, what could be the reason?
18. Q18 What is a "provider" in the context of the Snowflake Marketplace or Data Exchange?
19. Q19 Which of the following are examples of system-defined roles in Snowflake? (Choose any 3 options)
20. Q20 What does "warehouse scaling up/down" refer to in Snowflake?
21. Q21 What is the primary purpose of Snowflake's Cloning feature?
22. Q22 When unloading data from a Snowflake table, what is the target destination for the `COPY INTO @stage` command?
23. Q23 Which layer of the Snowflake architecture performs query optimization and execution?