COF-C02 Snowflake Exam Questions and Free Practice Test

Question 145

- (Topic 2)
Which Snowflake layer is always leveraged when accessing a query from the result cache?

A. Metadata

B. Data Storage

C. Compute

D. Cloud Services

Correct Answer:D
The Cloud Services layer in Snowflake is responsible for managing the result cache. When a query is executed, the results are stored in this cache, and subsequent identical queries can leverage these cached results without re-executing the entire query1.

Question 146

- (Topic 1)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A. Standard

B. Premium

C. Enterprise

D. Business Critical

Correct Answer:D
https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

Question 147

- (Topic 3)
Which TABLE function helps to convert semi-structured data to a relational representation?

A. CHECK_JSON

B. TO_JSON

C. FLATTEN

D. PARSE_JSON

Correct Answer:C
The FLATTEN table function in Snowflake is used to convert semi- structured data, such as JSON or XML, into a relational format. It expands nested arrays or objects into multiple rows, making the data suitable for relational querying3.

Question 148

- (Topic 5)
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

A. There are multiple SOL UDFs with the same names and the same number of arguments.

B. There are multiple SQL UDFs with the same names and the same number of argument types.

C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Correct Answer:C
In Snowflake, overloading refers to the creation of multiple User-Defined
Functions (UDFs) with the same name but differing in the number or types of their arguments. This feature allows for more flexible function usage, as Snowflake can differentiate between functions based on the context of their invocation, such as the types or the number of arguments passed. Overloading helps to create more adaptable and readable code, as the same function name can be used for similar operations on different types of data.
References:
✑ Snowflake Documentation: User-Defined Functions

Question 149

- (Topic 6)
Which function should be used to find the query ID of the second query executed in a current session?

A. Select LAST_QUERY_ID(-2)

B. Select LAST_QUERY_ID(2)

C. Select LAST_QUERY_ID(1)

D. Select LAST_QUERY_ID(2)

Correct Answer:A
The correct function to find the query ID of the second query executed in the current session isSELECT LAST_QUERY_ID(-2). TheLAST_QUERY_IDfunction returns the query ID for the most recent query executed in the session when called with no arguments. When used with an argument, it can retrieve the ID of previous queries within the same session, where-2would reference the second most recent query executed.
References:
✑ There's a clarification needed here; Snowflake's documentation indicatesLAST_QUERY_ID()function does not accept arguments. It returns the ID of the last query executed in the session. To find the query ID of the second last executed query, users typically need to track query IDs manually or use session history views.

Question 150

- (Topic 4)
What does a masking policy consist of in Snowflake?

A. A single data type, with one or more conditions, and one or more masking functions

B. A single data type, with only one condition, and only one masking function

C. Multiple data types, with only one condition, and one or more masking functions

D. Multiple data types, with one or more conditions, and one or more masking functions

Correct Answer:A
A masking policy in Snowflake consists of a single data type, with one or more conditions, and one or more masking functions. These components define how the data is masked based on the specified conditions3.

START COF-C02 EXAM