- (Topic 1)
Which cache type is used to cache data output from SQL queries?
Correct Answer:
B
TheResult cache is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance by storing the results of queries for a period of time. When the same or similar query is executed again, Snowflake can retrieve the result from this cache instead of re-computing the result, which saves time and computational resources.
References:
✑ Snowflake Documentation on Query Results Cache
✑ SnowPro® Core Certification Study Guide
- (Topic 1)
Which of the following commands cannot be used within a reader account?
Correct Answer:
A
In Snowflake, a reader account is a type of account that is intended for consuming shared data rather than performing any data management or DDL operations. The CREATE SHARE command is used to share data from your account with another account, which is not a capability provided to reader accounts. Reader accounts are typically restricted from creating shares, as their primary purpose is to read shared data rather than to share it themselves.
References:
✑ Snowflake Documentation on Reader Accounts
✑ SnowPro® Core Certification Study Guide
- (Topic 4)
Which function unloads data from a relational table to JSON?
Correct Answer:
B
The TO_JSON function is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 6)
Which virtual warehouse consideration can help lower compute resource credit consumption?
Correct Answer:
C
One key strategy to lower compute resource credit consumption in Snowflake is by automating the suspension and resumption of virtual warehouses. Virtual warehouses consume credits when they are running, and managing their operational times effectively can lead to significant cost savings.
A.Setting up a multi-cluster virtual warehouseincreases parallelism and throughput but does not directly lower credit consumption. It is more about performance scaling than cost efficiency.
B.Resizing the virtual warehouse to a larger sizeincreases the compute resources available for processing queries, which increases the credit consumption rate. This option does not help in lowering costs.
C.Automating the virtual warehouse suspension and resumption settings: This is a direct method to manage credit consumption efficiently. By automatically suspending a warehouse when it is not in use and resuming it when needed, you can avoid consuming credits during periods of inactivity. Snowflake allows warehouses to be configured to automatically suspend after a specified period of inactivity and to automatically resume when a query is submitted that requires the warehouse.
D.Increasing the maximum cluster count parameter for a multi-cluster virtual warehousewould potentially increase credit consumption by allowing more clusters to run simultaneously. It is used to scale up resources for performance, not to reduce costs. Automating the operational times of virtual warehouses ensures that you only consume compute credits when the warehouse is actively being used for queries, thereby optimizing your Snowflake credit usage.
Reference: Snowflake Documentation on Managing Warehouse Credit Usage
(https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#managing-warehouse-credit-usage)
- (Topic 3)
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Correct Answer:
D
Snowflake uses a technique called pruning to limit the number of micro- partitions scanned by each query. Pruning effectively filters out unnecessary micro- partitions based on the query??s filter conditions, which can significantly improve query performance by reducing the amount of data scanned1.
