Free SnowPro-Core Exam Dumps

Question 96

- (Exam Topic 2)
Which of the following describes how clustering keys work in Snowflake?

A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
B. Clustering keys sort the designated columns over time, without blocking DML operations
C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Correct Answer:B

Question 97

- (Exam Topic 1)
Which of the following terms best describes Snowflake’s database architecture?

A. Columnar shared nothing
B. Shared disk
C. Multi-cluster, shared data
D. Cloud-native shared memory

Correct Answer:C
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.

Question 98

- (Exam Topic 2)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A. True
B. False

Correct Answer:A

Question 99

- (Exam Topic 1)
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

A. When users will be using compute at different times throughout a 24/7 period
B. When managing a steady workload
C. When the compute must be available with no delay or lag time
D. When you don’t want to have to manually turn on the Warehouse each time a user needs it

Correct Answer:BC
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

Question 100

- (Exam Topic 3)
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
B. An error will occur, as views with qualified references cannot be cloned.
C. An error will occur, as stored objects cannot be cloned.
D. The stored procedures and views will refer to tables in the source database.

Correct Answer:D