- (Exam Topic 1)
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

1. A. When users will be using compute at different times throughout a 24/7 period
2. B. When managing a steady workload
3. C. When the compute must be available with no delay or lag time
4. D. When you don’t want to have to manually turn on the Warehouse each time a user needs it

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

- (Exam Topic 1)
What privileges are required to create a task?

1. A. The global privilege create task is required to create a new task.
2. B. Tasks are created at the Application level and can only be created by the Account Admin role.
3. C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
4. D. The role must have access to the target schema and the create task privilege on the schema itself.

Correct Answer: D
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

- (Exam Topic 3)
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake

Correct Answer: B

- (Exam Topic 3)
What is the minimum Snowflake edition required to use Dynamic Data Masking?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake (VPC)

Correct Answer: D

- (Exam Topic 2)
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

1. A. list @mytable;
2. B. list @%raytable;
3. C. list @ %m.ystage;
4. D. list @mystage;

Correct Answer: D