ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

SnowPro Core: SnowPro Core

Vendor:
Exam Questions:
627
 Learners
  2.370
Last Updated
April - 2025
Language
English
16 Quizzes
PDF | VPLUS
This study guide should help you understand what to expect on the exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.

Related questions

What is a key feature of Snowflake architecture?

Zero-copy cloning creates a mirror copy of a database that updates with the original
Zero-copy cloning creates a mirror copy of a database that updates with the original
Software updates are automatically applied on a quarterly basis
Software updates are automatically applied on a quarterly basis
Snowflake eliminates resource contention with its virtual warehouse implementation
Snowflake eliminates resource contention with its virtual warehouse implementation
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Suggested answer: C
Explanation:

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

asked 23/09/2024
Vu Tung
32 questions

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality
The table contains a column that has very low cardinality
DML statements that are being issued against the table are blocked
DML statements that are being issued against the table are blocked
The table has a small number of micro-partitions
The table has a small number of micro-partitions
Queries on the table are running slower than expected
Queries on the table are running slower than expected
The clustering depth for the table is large
The clustering depth for the table is large
Suggested answer: D, E
Explanation:

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

asked 23/09/2024
HAZEM SHAIKHANI
47 questions

How is unstructured data retrieved from data storage?

Become a Premium Member for full access
  Unlock Premium Member

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Become a Premium Member for full access
  Unlock Premium Member

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

Become a Premium Member for full access
  Unlock Premium Member

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Suggested answer: A
Explanation:

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

asked 23/09/2024
Harry Vervelde
44 questions

How can a Snowflake user traverse semi-structured data?

Become a Premium Member for full access
  Unlock Premium Member

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

Become a Premium Member for full access
  Unlock Premium Member

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Become a Premium Member for full access
  Unlock Premium Member

User-level network policies can be created by which of the following roles? (Select TWO).

ROLEADMIN
ROLEADMIN
ACCOUNTADMIN
ACCOUNTADMIN
SYSADMIN
SYSADMIN
SECURITYADMIN
SECURITYADMIN
USERADMIN
USERADMIN
Suggested answer: B, D
Explanation:

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

asked 23/09/2024
Suraj Patil
39 questions