SnowPro-Core Free Practice Test

- (Exam Topic 2)
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

1. A. The user has the appropriate privileges on the objects associated with the query
2. B. Micro-partitions have been reclustered since the query was last run
3. C. The new query is run using the same virtual warehouse as the previous query
4. D. The query includes a User Defined Function (UDF)
5. E. The query has been run within 24 hours of the previously-run query

Correct Answer: AE

- (Exam Topic 2)
Which cache type is used to cache data output from SQL queries?

1. A. Metadata cache
2. B. Result cache
3. C. Remote cache
4. D. Local file cache

Correct Answer: B
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

- (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)
How does Snowflake Fail-safe protect data in a permanent table?

1. A. Fail-safe makes data available up to 1 day, recoverable by user operations.
2. B. Fail-safe makes data available for 7 days, recoverable by user operations.
3. C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
4. D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Correct Answer: C

- (Exam Topic 1)
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

1. A. True
2. B. False

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