SnowPro-Core Free Practice Test

- (Exam Topic 1)
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

1. A. Concurrency
2. B. Performance

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

- (Exam Topic 1)
True or False: Snowflake charges additional fees to Data providers for each share they create.

1. A. True
2. B. False

Correct Answer: B
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

- (Exam Topic 1)
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

1. A. A Schema may contain one or more Databases
2. B. A Database may contain one or more Schemas
3. C. A Schema is a logical grouping of Database Objects
4. D. Each Schema is contained within a Warehouse

Correct Answer: BC
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

- (Exam Topic 2)
Which of the following are benefits of micro-partitioning? (Select TWO)

1. A. Micro-partitions cannot overlap in their range of values
2. B. Micro-partitions are immutable objects that support the use of Time Travel.
3. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
4. D. Rows are automatically stored in sorted order within micro-partitions
5. E. Micro-partitions can be defined on a schema-by-schema basis

Correct Answer: AD
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

- (Exam Topic 2)
Will data cached in a warehouse be lost when the warehouse is resized?

1. A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
2. B. Ye
3. C. because the compute resource is replaced in its entirety with a new compute resource.
4. D. N
5. E. because the size of the cache is independent from the warehouse size
6. F. Ye
7. G. became the new compute resource will no longer have access to the cache encryption key

Correct Answer: A