Free Snowflake COF-C02 Exam Dumps July 2026

TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.

For data loading using Snowpipe, the recommended file size is a compressed file greater than 10 MB and up to 100 MB. This size range is optimal for Snowpipe's continuous, micro-batch loading process, allowing for efficient and timely data ingestion without overwhelming the system with files that are too large or too small.

References:

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Snowpipe1

To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.

References:

Snowflake Documentation: Access Control

Data sharing in Snowflake allows for live, read-only access to data across different Snowflake accounts without the need to copy or transfer the data. One of the characteristics of data shares is the ability to use secure views. Secure views are used within data shares to restrict the access of shared data, ensuring that consumers can only see the data that the provider intends to share, thereby preserving privacy and security.

References:

Snowflake Documentation: Understanding Secure Views in Data Sharing

In Snowflake, when dealing with semi-structured data such as a JSON document stored in a VARIANT column, the proper syntax to extract a value is to use the column name followed by the path to the specific element. Since arrays in JSON are zero-indexed, the first element is referenced with [0]. Therefore, to extract the name from the first element of the elements array, the correct syntax is Source_column:elements[0].name. References: Snowflake Documentation on Semi-Structured Data

Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher.This feature is part of Snowflake's comprehensive approach to encryption key management, ensuring data security through regular rekeying1.References:[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake stores metadata for rows in micro-partitions, including the range of values for each column and the number of distinct values1.

Data Encryption in Snowflake:

A . After micro-partitioning: Data stored in Snowflake is encrypted at rest after it is organized into micro-partitions.

C . After loading into an internal stage: Snowflake encrypts all data stored in internal stages automatically.

Why Other Options Are Incorrect:

B . After loading into a table: Encryption occurs during the micro-partitioning stage, which precedes this step.

D . External stage: Data encryption in external stages depends on the external storage provider, not Snowflake.

E . Only when using an encrypted stage: This is incorrect because encryption is automatic for internal stages and tables.

Data Encryption in Snowflake

In SQL, NULL values are not equal to other NULL values. To make comparisons work in join operations, the NVL function can replace NULL with a non-NULL value.

Example:

SELECT *

FROM table1 t1

JOIN table2 t2

ON NVL(t1.col, 'default') = NVL(t2.col, 'default');

Why Other Options Are Incorrect:

B . Equal_null function: No such function exists in Snowflake SQL.

C . NULLIF function: Used to return NULL when two values are equal, not for handling NULL in joins.

D . IFNULL function: Similar to NVL but less commonly used in this context.

NVL Function Documentation

Transient Tables:

These are storage objects designed to store data beyond a single session.

They do not incur Fail-safe costs, making them more cost-effective than permanent tables for temporary or intermediate data storage.

Why Other Options Are Incorrect:

A . Permanent table: Supports Fail-safe and incurs additional costs.

B . External table: Stores metadata for external data but does not store actual data.

C . Temporary table: Data persists only within a session and is not suitable for multi-session use.

Transient Tables Documentation