SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which statement MOST accurately describes clustering in Snowflake?

1. A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
2. B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
3. C. The clustering key must be included in the COPY command when loading data into Snowflake.
4. D. Clustering can be disabled within a Snowflake account.

Correct Answer: B

- (Exam Topic 3)
What is the purpose of multi-cluster virtual warehouses?

1. A. To create separate data warehouses to increase query optimization
2. B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
3. C. To eliminate or reduce Queuing of concurrent queries
4. D. To allow the warehouse to resize automatically

Correct Answer: C
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi-cluster warehous

- (Exam Topic 3)
What is cached during a query on a virtual warehouse?

1. A. All columns in a micro-partition
2. B. Any columns accessed during the query
3. C. The columns in the result set of the query
4. D. All rows accessed during the query

Correct Answer: B

- (Exam Topic 1)
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

1. A. Installing and configuring hardware
2. B. Patching software
3. C. Physical security
4. D. Maintaining metadata and statists

Correct Answer: ABD