Snowflake SnowPro Core Certification COF-C02 Exam Questions

Answer : B

The maximum Time Travel retention period for a temporary Snowflake table is 1 day.This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window

Answer : C

The Snowflake command to unload the result of a query to a single file isCOPY INTO <internal stage> with SINGLE = TRUEfollowed by aGETcommand to download the file.This command unloads the query result into a single file in the specified internal stage

Answer : D

The function used to determine the kind of value stored in a VARIANT column in Snowflake is TYPEOF.

Understanding VARIANT Data Type:

VARIANT is a flexible data type in Snowflake that can store semi-structured data, such as JSON, Avro, and XML.

This data type can hold values of different types, including strings, numbers, objects, arrays, and more.

Using TYPEOF Function:

The TYPEOF function returns the data type of the value stored in a VARIANT column.

It helps in identifying the type of data, which is crucial for processing and transforming semi-structured data accurately.

Example Usage:

SELECT TYPEOF(variant_column)

FROM my_table;

This query retrieves the type of data stored in variant_column for each row in my_table.

Possible return values include 'OBJECT', 'ARRAY', 'STRING', 'NUMBER', etc.

Benefits:

Simplifies data processing: Knowing the data type helps in applying appropriate transformations and validations.

Enhances query accuracy: Ensures that operations on VARIANT columns are performed correctly based on the data type.

References:

Snowflake Documentation: TYPEOF

Snowflake Documentation: VARIANT Data Type

Answer : A

The role that can by default create resource monitors in Snowflake is the ACCOUNTADMIN role. Resource monitors are a crucial feature in Snowflake that allows administrators to track and control the consumption of compute resources, ensuring that usage stays within specified limits. The creation and management of resource monitors involve defining thresholds for credits usage, setting up notifications, and specifying actions to be taken when certain thresholds are exceeded.

Given the significant impact that resource monitors can have on the operational aspects and billing of a Snowflake account, the capability to create and manage them is restricted to the ACCOUNTADMIN role. This role has the broadest set of privileges in Snowflake, including the ability to manage all aspects of the account, such as users, roles, warehouses, databases, and resource monitors, among others.

References:

Snowflake Documentation on Resource Monitors: Managing Resource Monitors

Answer : C

The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application.

References:

Snowflake Documentation: Generating Presigned URLs

Answer : B

In Snowflake, the ACCOUNTADMIN role is required to create resource monitors. Resource monitors are used to manage and monitor the consumption of compute resources. The ACCOUNTADMIN role has the necessary privileges to create, configure, and manage resource monitors across the account.

References:

Snowflake Documentation: Resource Monitors

Answer : A, C

In the execution time summary of a Query Profile in Snowflake, the categories included provide insights into various aspects of query execution. 'Pruning' refers to the process by which Snowflake reduces the amount of data scanned by eliminating partitions of data that are not relevant to the query, thus improving performance. 'Initialization' represents the time taken for query planning and setup before actual execution begins. These metrics are crucial for understanding and optimizing query performance.