SnowPro Core Certification Free Practice Exam Questions

1321 real SnowPro Core Certification exam questions with answers and AI explanations. Snowflake certification prep — page 26 of 133.

1. Question 254: In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Choose two.)
2. Question 255: A clustering key was defined on a table, but it is no longer needed. How can the key be removed?
3. Question 256: Which data types does Snowflake support when querying semi-structured data? (Choose two.)
4. Question 257: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
5. Question 258: Which data type is supported by Snowflake data classification?
6. Question 259: While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?
7. Question 260: How would a user run a multi-cluster warehouse in maximized mode?
8. Question 261: What internal stages are available in Snowflake? (Choose three.)
9. Question 262: Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
10. Question 263: User-level network policies can be created by which of the following roles? (Choose two.)