- (Topic 5)
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Correct Answer:
CD
Valid sub-clauses to theOVERclause for a window function in SQL are:
✑ C. ORDER BY: This clause specifies the order in which the rows in a partition are processed by the window function. It is essential for functions that depend on the row order, such as ranking functions.
✑ D. PARTITION BY: This clause divides the result set into partitions to which the window function is applied. Each partition is processed independently of other partitions, making it crucial for functions that compute values across sets of rows that share common characteristics.
These clauses are fundamental to defining the scope and order of data over which the window function operates, enabling complex analytical computations within SQL queries. References:
✑ Snowflake Documentation: Window Functions
- (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 6)
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Correct Answer:
B
TheJAROWINKLER_SIMILARITYfunction in Snowflake returns an integer between 0 and 100, indicating the similarity of two strings based on the Jaro-Winkler similarity algorithm. This function is useful for comparing strings and determining how closely they match each other.
✑ Understanding JAROWINKLER_SIMILARITY:The Jaro-Winkler similarity metric is
a measure of similarity between two strings. The score is a number between 0 and 100, where 100 indicates an exact match and lower scores indicate less similarity.
✑ Usage Example:To compare two strings and get their similarity score, you can
use: SELECTJAROWINKLER_SIMILARITY('string1','string2')ASsimilarity_score;
✑ Application Scenarios:This function is particularly useful in data cleaning,
matching, and deduplication tasks where you need to identify similar but not identical strings, such as names, addresses, or product titles.
Reference:For more detailed information on theJAROWINKLER_SIMILARITYfunction and its usage, refer to the Snowflake documentation on string functions: https://docs.snowflake.com/en/sql-reference/functions/jarowinkler_similarity.html
- (Topic 3)
Which privilege is required for a role to be able to resume a suspended warehouse if auto- resume is not enabled?
Correct Answer:
B
The OPERATE privilege is required for a role to resume a suspended warehouse if auto-resume is not enabled. This privilege allows the role to start, stop, suspend, or resume a virtual warehouse3.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 2)
The is the minimum Fail-safe retention time period for transient tables?
Correct Answer:
D
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days. This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables
