- (Topic 1)
What is the purpose of an External Function?
Correct Answer:
A
The purpose of an External Function in Snowflake is to call code that executes outside of the Snowflake environment. This allows Snowflake to interact with external services and leverage functionalities that are not natively available within Snowflake, such as calling APIs or running custom code hosted on cloud services3. https://docs.snowflake.com/en/sql-reference/external-functions.html
- (Topic 3)
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
* 1. Created a user called "CONSUMER"
* 2. Created a database to hold the share and an extra-small warehouse to query the data
* 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?
Correct Answer:
B
The reader account compute will be billed to the provider account.
Very Comprehensive Explanation
In Snowflake, when a provider creates a reader account for a consumer who does not have a Snowflake account, the compute resources used by the reader account are billed to the provider??s account. This allows the consumer to query the shared data without incurring any costs. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 2)
When cloning a database, what is cloned with the database? (Choose two.)
Correct Answer:
AB
When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc. However, it does not include future child objects or privileges on schemas within the database2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
- (Topic 1)
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Correct Answer:
DE
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 canlead 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.
References:
✑ Snowflake Documentation on Clustering Keys & Clustered Tables
✑ Snowflake Documentation on SYSTEM$CLUSTERING_INFORMATION
✑ Stack Overflow discussion on cluster key selection in Snowflake
- (Topic 2)
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)