SnowPro Core Certification Free Practice Exam Questions

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

1. Question 1262: Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)
2. Question 1263: What happens when a table or schema with a standard retention period is dropped?
3. Question 1264: When cloning tables, which INFORMATION_SCHEMA view will show different columns for owned storage and referenced storage?
4. Question 1265: When working with dimension tables that change frequently, what is the recommended way to manage costs?
5. Question 1266: What Snowflake privilege should be granted to allow a non-ACCOUNTADMIN access to billing information?
6. Question 1267: A stream can be created on which Snowflake objects to record data manipulation language (DML) changes? (Choose two.)
7. Question 1268: When creating a file format to load JSON data into Snowflake, what command will remove brackets ([]) from the data?
8. Question 1269: What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries, by offloading portions of the query proc…
9. Question 1270: Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
10. Question 1271: Which privilege must be granted to show data categories in a Data Exchange?