SnowPro-Core Free Practice Test

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

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 2)
Which Snowflake feature is used for both querying and restoring data?

1. A. Cluster keys
2. B. Time Travel
3. C. Fail-safe
4. D. Cloning

Correct Answer: B
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake provides powerful%

- (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