SnowPro Core: SnowPro Core
Related questions
What is a key feature of Snowflake architecture?
One of the key features of Snowflake's architecture is its unique approach to eliminating resource contention through the use of virtual warehouses. This is achieved by separating storage and compute resources, allowing multiple virtual warehouses to operate independently on the same data without affecting each other. This means that different workloads, such as loading data, running queries, or performing complex analytics, can be processed simultaneously without any performance degradation due to resource contention.
Snowflake Documentation on Virtual Warehouses
SnowPro Core Certification Study Guide
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
A clustering key in Snowflake is used to co-locate similar data within the same micro-partitions to improve query performance, especially for large tables where data is not naturally ordered or has become fragmented due to extensive DML operations. The appropriate use of a clustering key can lead to improved scan efficiency and better column compression, resulting in faster query execution times.
The indicators that it may be appropriate to use a clustering key for a table include:
D) Queries on the table are running slower than expected: This can happen when the data in the table is not well-clustered, leading to inefficient scans during query execution.
E) The clustering depth for the table is large: A large clustering depth indicates that the table's data is spread across many micro-partitions, which can degrade query performance as more data needs to be scanned.
Snowflake Documentation on Clustering Keys & Clustered Tables
Snowflake Documentation on SYSTEM$CLUSTERING_INFORMATION
Stack Overflow discussion on cluster key selection in Snowflake
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. This means that the performance of these queries can improve due to the increased resources.Conversely, when the size of a warehouse is reduced, the compute resources are not removed until they are no longer being used by any current operations1.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Virtual Warehouses2
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Network Policies1
Section 1.3 - SnowPro Core Certification Study Guide
Question