- (Exam Topic 1)
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/credits.html

- (Exam Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D

- (Exam Topic 2)
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

1. A. Data is hashed by the cluster key to facilitate fast searches for common data values
2. B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
3. C. Smaller micro-partitions are created for common data values to allow for more parallelism
4. D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Correct Answer: D

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

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