COF-C03 Exam Dumps - SnowPro Core Certification 2026 Exam

In Snowflake, when dealing with semi-structured data such as a JSON document stored in aVARIANTcolumn, 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 thenamefrom the first element of theelementsarray, the correct syntax isSource_column:elements[0] .name.

TheGET_PRESIGNED_URLfunction in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the file.

Generate Pre-Signed URL:

SELECT GET_PRESIGNED_URL(@my_stage/file.txt);

Share the URL:The generated URL can be shared with external users or applications, enabling them to access the file directly.

For a private GitHub repository accessed over HTTPS, Snowflake can authenticate using a GitHub personal access token. The token is stored securely in a Snowflake secret rather than written directly into the Git repository object.

The secret is referenced by the API integration or Git repository configuration. For GitHub, a personal access token is generally supplied in the password field of a password-type Snowflake secret.

A normal GitHub account password is not the recommended authentication mechanism for Git operations. Interactive MFA cannot be performed by Snowflake when it synchronizes a repository. An arbitrary OAuth token is not the standard answer for the documented private-GitHub setup represented by this question.

In Snowflake, network policies define the allowed IP address ranges from which users can connect to Snowflake, enhancing security by restricting access based on network location. The creation and management of network policies require sufficient privileges. Specifically, a user with theSECURITYADMINrole or any role with higher privileges, such asACCOUNTADMIN, can create network policies. Additionally, a custom role can be granted theCREATE NETWORK POLICYprivilege, enabling users assigned to that role to also create network policies. This approach allows for flexible and secure management of network access to Snowflake.

The correct answer is B. Only one refresh will run at a time .

Failover groups can be refreshed on a schedule to replicate supported account objects and database objects to target accounts. Snowflake does not run overlapping refresh operations for the same failover group.

Why B is correct:

If a scheduled refresh is still running, Snowflake does not start another concurrent refresh for the same failover group. Refresh operations are managed so that only one refresh runs at a time.

Why the other options are incorrect:

A. Multiple refreshes for the same failover group do not run concurrently.

C. Refreshes still require the appropriate privileges and configured replication/failover group permissions.

D. A delayed or long-running refresh does not mean the next refresh is automatically canceled in the way stated. The key behavior is that refreshes do not overlap.

Official Snowflake documentation reference:

Snowflake documentation for replication and failover groups explains that scheduled refreshes are managed by Snowflake and that refresh operations do not run concurrently for the same group.

The correct answer is D. To return the first non-NULL expression in an argument .

COALESCE evaluates its arguments from left to right and returns the first expression that is not NULL. If all expressions are NULL, it returns NULL.

Why D is correct:

SELECT COALESCE(phone_mobile, phone_home, phone_work, ' No phone ' ) AS contact_phone

FROM customers;

This returns the first available non-NULL phone number. If all phone columns are NULL, it returns ' No phone ' .

Why the other options are incorrect:

A. Splitting strings is handled by functions such as SPLIT.

B. Removing duplicates is handled with DISTINCT, grouping, or deduplication logic.

C. Joining column values is usually done with concatenation functions or operators, such as CONCAT.

Official Snowflake documentation reference:

Snowflake documentation describes COALESCE as a conditional expression that returns the first non-NULL expression among its arguments.