COF-C03 Exam Dumps - SnowPro Core Certification 2026 Exam

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.

In Snowflake, if a table is accidentally dropped but still within the data retention period (also known as " Time Travel " ), the simplest and most efficient recovery method is the UNDROP command. This command restores the deleted table to its previous state with minimal operational effort. Since Snowflake retains dropped table data for a specific retention period (up to 90 days for the Enterprise edition), UNDROP can quickly recover the table without the need for complex cloning or data reloading processes, making it ideal for accidental deletions.

Granting a user the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses in Snowflake is equivalent to granting the global MANAGE WAREHOUSES privilege. These privileges collectively provide comprehensive control over virtual warehouses.

MODIFY Privilege:

Allows users to change the configuration of the virtual warehouse.

Includes resizing, suspending, and resuming the warehouse.

MONITOR Privilege:

Allows users to view the status and usage metrics of the virtual warehouse.

Enables monitoring of performance and workload.

OPERATE Privilege:

Grants the ability to start and stop the virtual warehouse.

Includes pausing and resuming operations as needed.

Snowflake Documentation: Warehouse Privileges

The correct answers are A. Document AI and E. Cortex Analyst .

Snowflake Cortex is Snowflake’s integrated AI and machine learning capability set. It includes features for working with language models, document extraction, natural language analytics, and AI-powered application development.

Why A is correct:

Document AI is part of Snowflake Cortex. It is used to extract information from unstructured documents using AI.

Why E is correct:

Cortex Analyst is part of Snowflake Cortex. It enables natural language questions over structured data by using semantic models and Cortex capabilities.

Why the other options are incorrect:

B. Snowpipe is a data ingestion service, not part of the Cortex AI suite.

C. Streams are change data capture objects used to track table changes, not Cortex AI components.

D. Secure views are security/governance objects used to protect view definitions and support secure data sharing, not Cortex AI components.

Official Snowflake documentation reference:

Snowflake documentation describes Snowflake Cortex as a set of AI and ML capabilities and includes features such as Document AI and Cortex Analyst. Snowpipe, streams, and secure views belong to other Snowflake feature areas.

The ORGADMIN role in Snowflake is designed to manage organization-level activities. This role can perform several tasks that span across multiple accounts within the organization.

View Usage Information:The ORGADMIN role can view usage statistics and billing information for all accounts within the organization.

-- Example: Viewing usage information

SELECT *

FROM organization_usage_history;

Enable Database Replication:The ORGADMIN role has the authority to enable and manage database replication for accounts within the organization.

-- Example: Enabling database replication

ALTER DATABASE my_database ENABLE REPLICATION TO ACCOUNT other_account;

Snowflake’s Time Travel feature allows users to access historical data within a specific period. This feature supports the restoration of various objects, including databases and schemas, to their previous states. Time Travel can be used for recovering dropped objects, undoing accidental changes, or analyzing data changes over time. However, it does not support user or role objects like Users and Roles, or compute resources like Virtual Warehouses.