Free Snowflake SnowPro Core Certification 2026 Exam COF-C03 Exam Questions

To minimize Continuous Data Protection (CDP) costs when dealing with large, high-churn dimension tables in Snowflake, using transient tables is a recommended approach.

Transient Tables: These are designed for data that does not require fail-safe protection. They provide the benefit of reducing costs associated with continuous data protection since they do not have the seven-day Fail-safe period that is mandatory for permanent tables.

Periodic Copying to Permanent Tables: By periodically copying data from transient tables to permanent tables, you can achieve a balance between data protection and cost-efficiency. Permanent tables offer the extended data protection features, including Time Travel and Fail-safe, butthese features can be applied selectively rather than continuously, reducing the overall CDP costs.

:

Snowflake Documentation on Transient Tables

Snowflake Documentation on Time Travel & Fail-safe

The Fail-safe period for a transient table in Snowflake, regardless of the edition (including Enterprise edition and higher), is 0 days. Fail-safe is a data protection feature that provides additional retention beyond the Time Travel period for recovering data in caseof accidental deletion or corruption. However, transient tables are designed for temporary or short-term use and do not benefit from the Fail-safe feature, meaning that once their Time Travel period expires, data cannot be recovered.

Snowflake Documentation: Understanding Fail-safe

Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others.This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.

PARSE_DOCUMENT is used to extract information from documents, including text and layout elements. It is part of Snowflake Cortex document processing functionality.

Why the other options are incorrect:

TRANSCRIBE is for audio transcription, COMPLETE is for large language model completion, and EMBED generates vector embeddings.

==

To unload data from a relational table to JSON format, you can use the TO_CHAR function. This function converts a number to a character string, which can then be serialized into JSON format. While there isn't a direct function specifically named for unloading to JSON, converting the necessary fields to a string representation is a common step in preparing data for JSON serialization.

:

Snowflake Documentation: TO_CHAR Function

Object tagging in Snowflake allows users to assign metadata labels to various database objects to improve data governance and access control. Tags can be used to categorize and manage data based on business needs, helping to enforce governance policies and streamline database administration.

:

Snowflake Documentation: Object Tagging

When a cloned table is replicated to a secondary database in Snowflake, the following occurs:

C . The physical data is replicated: The actual data of the cloned table is physically replicated to the secondary database.This ensures that thesecondary database has its own copy of the data, which can be used for read-only purposes or failover scenarios1.

E . Metadata pointers to cloned tables are replicated: Along with the physical data, the metadata pointers that refer to the cloned tables are also replicated.This metadata includes information about the structure of the table and any associated properties2.

It's important to note that while the physical data and metadata are replicated, the secondary database is typically read-only and cannot be used for write operations. Additionally, while there may be additional storage costs associated with the secondary account, this is not a direct result of the replication process but rather a consequence of storing additional data.

SnowPro Core Exam Prep --- Answers to Snowflake's LEVEL UP: Backup and Recovery

Snowflake SnowPro Core Certification Exam Questions Set 10

The correct answer is D. MANAGE GRANTS.

The MANAGE GRANTS privilege allows a role to grant and revoke privileges on objects. If this privilege is revoked, the role loses the broad ability to manage privileges for other roles.

Why D is correct:

MANAGE GRANTS is a powerful global privilege. It allows a role to grant and revoke privileges, even on objects the role does not own, depending on Snowflake's access control rules.

Why the other options are incorrect:

A . USAGE allows access to an object or namespace, such as a database, schema, warehouse, or integration. It does not allow broad grant management.

B . MODIFY allows changes to certain object properties or data, depending on the object type, but it does not broadly allow granting privileges to roles.

C . REFERENCES is related to referencing objects, such as in constraints or policies. It does not control grant administration.

Official Snowflake documentation reference:

Snowflake documentation describes MANAGE GRANTS as the global privilege that enables granting and revoking privileges on objects.

==

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.

Snowflake Documentation: GET_PRESIGNED_URL

Snowflake Documentation: Working with Stages

When a running virtual warehouse in Snowflake issuspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.

The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object.This function is particularly useful for working with semi-structured data in Snowflake

The Snowflake Search Optimization Service is designed to enhance the performance of specific types of queries on large tables. The correct answer is:

D . It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions.

This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.

Snowflake Documentation: Search Optimization Service at Snowflake Documentation