SnowPro Core Certification Free Practice Exam Questions

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

1. Question 679: The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)
2. Question 680: Snowflake’s hierarchical key mode includes which keys? (Choose two.)
3. Question 681: What is a characteristic of materialized views in Snowflake?
4. Question 682: What privileges are necessary for a consumer in the Data Exchange to make a request and receive data? (Choose two.)
5. Question 683: Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse m…
6. Question 684: There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from…
7. Question 685: A user is unloading data to a stage using this command: copy into @message from (select object_construct('id', 1, 'first_name', 'Snowflake', 'last_name', 'User…
8. Question 686: A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data. Ho…
9. Question 687: When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
10. Question 688: Which key governance feature in Snowflake allows users to identify data objects that contain sensitive data and their related objects?