SnowPro-Core Free Practice Test

- (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

- (Exam Topic 1)
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

1. A. Database
2. B. Tables
3. C. Warehouses
4. D. Worksheets

Correct Answer: ACD
Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html

- (Exam Topic 1)
Which of the following statements is true of Snowflake micro-partitioning?

1. A. Micro-partitioning has been known to introduce data skew
2. B. Micro-partitioning: requires a partitioning schema to be defined up front
3. C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
4. D. Micro-partitioning can be disabled within a Snowflake account

Correct Answer: C
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

- (Exam Topic 1)
Snowflake is designed for which type of workloads? (Choose two.)

1. A. OLAP (Analytics) workloads
2. B. OLTP (Transactional) workloads
3. C. Concurrent workloads
4. D. On-premise workloads

Correct Answer: AC
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing