- (Topic 1)
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
Correct Answer:
AB
To address a high volume of queries queuing in a warehouse, Snowflake recommends two best practices:
✑ A. Use multi-clustered warehousing to scale out warehouse capacity: This approach allows for the distribution of queries across multiple clusters within a warehouse, effectively managing the load and reducing the queue volume.
✑ B. Scale up the warehouse size to allow Queries to execute faster: Increasing the size of the warehouse provides more compute resources, which can reduce the time it takes for queries to execute and thus decrease the number of queries waiting in the queue.
These strategies help to optimize the performance of the warehouse by ensuring that resources are scaled appropriately to meet demand.
References:
✑ Snowflake Documentation on Multi-Cluster Warehousing
✑ SnowPro Core Certification best practices
- (Topic 6)
What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
Correct Answer:
D
Snowflake recommends considering adding a clustering key to a table when its size reaches1 Terabyte (TB)or larger. Clustering keys help optimize the storage and query performance by organizing the data in a table based on the specified columns. This is particularly beneficial for large tables where data retrieval can become inefficient without proper clustering.
✑ Why Clustering Keys Are Important:Clustering keys ensure that data stored in Snowflake is physically ordered in a way that aligns with the most frequent accesspatterns, thereby reducing the amount of scanned data during queries and improving performance.
✑ Recommendation Basis:The recommendation for tables of size 1 TB or larger is based on the observation that smaller tables generally do not benefit as much from clustering, given Snowflake's architecture. However, as tables grow in size, the benefits of clustering become more pronounced.
✑ Implementing Clustering Keys:
CREATETABLEmy_table (... ) CLUSTERBY(column1, column2);
✑ uk.co.certification.simulator.questionpool.PList@40668a0f ALTERTABLEmy_table CLUSTERBY(column1, column2);
Reference:For additional information on clustering in Snowflake and recommendations on when to use clustering keys, consult the Snowflake documentation on managing and optimizing data clustering: https://docs.snowflake.com/en/user-guide/tables-clustering- keys.html
- (Topic 1)
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Correct Answer:
A
Snowflake??s architecture allows for the use of a query result cache that stores the results of queries for a period of time. If the same query is run again and the underlying data has not changed, Snowflake can retrieve the result from this cache without needing to re-run the query on an active warehouse, thus saving on compute resources.
- (Topic 6)
Which key access control concept does Snowflake descibe as a defined level of access to an object?
Correct Answer:
B
In Snowflake, the term "privilege" refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake??s access control framework.References:Snowflake Documentation on Access Control Privileges
- (Topic 6)
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Correct Answer:
B
