- (Exam Topic 1)
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

1. A. The complexity of each query
2. B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
3. C. The size of the data required for each query
4. D. The tool that s executing the query

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

- (Exam Topic 3)
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

1. A. Removing a column from the query SELECT list
2. B. Stopping the virtual warehouse that the query is running against
3. C. Clustering of the data used by the query
4. D. Executing the RESULTS_SCAN() table function
5. E. Changing a column that is not in the cached query

Correct Answer: AD

- (Exam Topic 3)
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

1. A. Organize files into logical paths
2. B. Store the files on the external stage to ensure caching is maintained
3. C. Use pattern matching for regular expression execution
4. D. Load the data in one large file

Correct Answer: D

- (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 2)
What is the minimum Snowflake edition required to create a materialized view?

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

Correct Answer: B
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%