SnowPro-Core Free Practice Test

- (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 1)
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

1. A. True
2. B. False

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

- (Exam Topic 2)
What are ways to create and manage data shares in Snowflake? (Select TWO)

1. A. Through the Snowflake web interface (Ul)
2. B. Through the DATA_SHARE=TRUE parameter
3. C. Through SQL commands
4. D. Through the enable share=true parameter
5. E. Using the CREATE SHARE AS SELECT * TABLE command

Correct Answer: CD

- (Exam Topic 3)
A materialized view should be created when which of the following occurs? (Choose two.)

1. A. There is minimal cost associated with running the query.
2. B. The query consumes many compute resources every time it runs.
3. C. The base table gets updated frequently.
4. D. The query is highly optimized and does not consume many compute resources.
5. E. The results of the query do not change often and are used frequently.

Correct Answer: CE

- (Exam Topic 2)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

1. A. The primary cluster in the virtual warehouse
2. B. The entire virtual warehouse
3. C. The database in which the virtual warehouse resides
4. D. The Queries currently being run on the virtual warehouse

Correct Answer: B
https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly, auto-resum