SnowPro Core Certification Free Practice Exam Questions

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

1. Question 1212: Which virtual warehouse configuration is recommended specifically for a steady workload that has no execution lag?
2. Question 1213: Which role allows a Snowflake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by default?
3. Question 1214: This statement is run: SELECT { 'key' : { 'subkey': 'value' }} mycolumn; What notations will retrieve the 'value' from the VARIANT column? (Choose two.)
4. Question 1215: Which multi-cluster virtual warehouse setting will help process queued queries as quickly as possible?
5. Question 1216: Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?
6. Question 1217: How can a Snowflake user access near real-time metrics that can be used to identify queries affected by disk spilling?
7. Question 1218: Which table type is used in the file processing pipeline to process unstructured data in Snowflake?
8. Question 1219: Which metrics in the QUERY_HISTORY Account _Usage View can be used to assess the pruning efficiency of a query? (Choose two.)
9. Question 1220: How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?
10. Question 1221: When unloading Snowflake relational data to a Parquet file format, why should the PARTITION BY clause be used?