- (Exam Topic 1)
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

1. A. Scaling rhythmically
2. B. Scaling max
3. C. Scaling out
4. D. Scaling up

Correct Answer: D

- (Exam Topic 2)
Where would a Snowflake user find information about query activity from 90 days ago?

1. A. Account___usage . query history view
2. B. account___usage.query___history___archive View
3. C. information___schema . cruery_history view
4. D. information___schema - query history_by_ses s i on view

Correct Answer: A

- (Exam Topic 3)
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

1. A. Configure the user to be initially disabled.
2. B. Force an immediate password change.
3. C. Set a default role for the user.
4. D. Set the number of minutes to unlock to 15 minutes.
5. E. Set the user's access to expire within a specified timeframe.

Correct Answer: AE

- (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 1)
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html