COF-C02 Premium PDF & Test Engine Files with 1110 Questions & Answers [Q95-Q115]

admin
September 29, 2026

COF-C02 Premium PDF & Test Engine Files with 1110 Questions & Answers [Q95-Q115]

Rate this post

COF-C02 Premium PDF & Test Engine Files with 1110 Questions & Answers

Get 100% Real COF-C02 Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!

Snowflake COF-C02 Exam Syllabus Topics:

Section	Weight	Objectives
Cloud Architecture and Data Loading	20-25%	– Data Loading Techniques 1. Bulk Loading (COPY INTO) 2. Continuous Loading 3. Data Loading Best Practices – Snowflake Architecture Overview 1. Snowflake Editions 2. Multi-cluster Warehouses 3. Layers (Storage, Compute, Services) 4. Virtual Warehouses
Data Handling and Transformation	15-20%	– Data Transformation 1. Data Pipelines 2. Snowflake SQL Functions 3. Time Travel Features – Semi-Structured Data 1. Flattening Data 2. JSON/Avro/Parquet Handling 3. VARIANT Data Type
Account Access and Security	20-25%	– Authentication 1. Multi-Factor Authentication 2. User/Role Management 3. SSO Integration – Network Security 1. Network Policies 2. Private Connectivity – Authorization 1. Grant/Revoke Commands 2. Object Privileges 3. Role Hierarchy
Billing and Account Management	10-15%	– Account Operations 1. Database/Schema Management 2. Account Parameters 3. Object Naming Conventions – Credit Usage 1. Resource Monitors 2. Credit Monitoring
Performance Optimization	20-25%	– Data Optimization 1. Search Optimization Service 2. Materialized Views 3. Clustering Keys – Query Performance 1. Result Set Caching 2. Query Profiling 3. Query History – Warehouse Optimization 1. Multi-cluster Configuration 2. Warehouse Sizing 3. Auto-Suspend/Auto-Resume

NO.95 What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

GROUP BY

LIMIT

ORDER BY

PARTITION BY

UNION ALL

NO.96 True or False: A Virtual Warehouse can be resized while suspended.

True

False

Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust performance and cost. When a warehouse is suspended, it is not currently running any queries, but its definition and metadata remain intact, allowing for modifications like resizing.
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

NO.97 What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

The clone always stays in sync with the original table.

The clone has better query performance.

The clone is created almost instantly.

The clone will have time travel history from the original table.

The clone saves space by not duplicating storage.

NO.98 What is the recommended compressed file size range for continuous data loads using Snowpipe?

8-16 MB

16-24 MB

10-99 MB

100-250 MB

NO.99 Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

Security

Data storage

Data visualization

Query computation

Metadata management

The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). Reference: Based on general cloud architecture knowledge as of 2021.

NO.100 A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?

Snowflake will resolve them according to the SEARCH_PATH parameter.

Snowflake will only check the schema the UDF belongs to.

Snowflake will first check the current schema, and then the schema the previous query used

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

* Object Name Resolution: When unqualified object names (e.g., table name without schema) are used in a UDF, Snowflake follows a specific hierarchy to resolve them. Here’s the order:
* Current Schema: Snowflake first checks if an object with the given name exists in the schema currently in use for the session.
* PUBLIC Schema: If the object isn’t found in the current schema, Snowflake looks in the PUBLIC schema of the current database.
* Note: TheSEARCH_PATHparameter influences object resolution for queries, not within UDFs.
References:
Snowflake Documentation (Object Naming Resolution): https://docs.snowflake.com/en/sql-reference/name- resolution.html

NO.101 Which privilege is needed for a SnowFlake user to see the definition of a secure view?

OWNERSHIP

MODIFY

CREATE

USAGE

NO.102 A Snowflake account holds data that will be consumed by a BI tool. Most of the BI users are located in the United States, but some users will require access from abroad with different levels of concurrency.
What virtual warehouse would be MOST cost-efficient?

A maximized multi-cluster warehouse with the minimum number of clusters that are big enough to handle the expected maximum concurrency.

A large enough standard warehouse able to handle the expected maximum concurrency.

A large enough Snowpark-optimized warehouse that will have sufficient memory to handle the expected maximum concurrency.

An auto-scale, multi-cluster warehouse with a maximum number of clusters that are large enough to handle the expected maximum concurrency.

NO.103 Which role has the ability to create and manage users and roles?

ORGADMIN

USERADMIN

SYSADMIN

SECURITYADMIN

The USERADMIN role in Snowflake has the ability to create and manage users and roles within the Snowflake environment. This role is specifically dedicated to user and role management and creation

NO.104 Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

DELETE

DROP

REMOVE

TRUNCATE

NO.105 How long is Snowpipe data load history retained?

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the data load operations performed by Snowpipe over a significant period of time, which can be crucial for troubleshooting and ensuring data integrity.
References:
* [COF-C02] SnowPro Core Certification Exam Study Guide
* Snowflake Documentation on Snowpipe1

NO.106 Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

A well-clustered table in Snowflake means that the data is organized in such a way that related data points are stored close to each other within the micro-partitions. This optimizes query performance by reducing the amount of scanned data. The diagram indicated by option C shows a well-clustered table, as it likely represents a more evenly distributed range of values across the micro-partitions1.
References = Snowflake Micro-partitions & Table Clustering

NO.107 Which Snowflake view is used to support compliance auditing?

ACCESS_HISTORY

COPY_HISTORY

QUERY_HISTORY

ROW ACCESS POLICIES

The ACCESS_HISTORY view in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries. This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.

NO.108 How can the outer array structure of a semi-structured file be removed?

Use the parameter strip_outer_array = true in a COPY INTO <table> command.

Set the file format to eliminate any outer array structure before initiating the COPY INTO <table> command.

Filter the outer array structure using a PUT command with the include_outer_array = false parameter.

Use the FLATTEN command with the outer_array = false parameter.

In Snowflake, the parameter strip_outer_array = true can be set in the COPY INTO <table> command to remove the outer array structure from a semi-structured file. This parameter is useful for JSON files or similar data formats where an array might wrap the data, allowing Snowflake to directly load the inner elements as table rows.

NO.109 Which Snowflake partner specializes in data catalog solutions?

Alation

DataRobot

dbt

Tableau

Explanation
Alation provides Data Cataloging functionality. They state they are the ‘One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html

NO.110 Which features make up Snowflake’s column level security? (Select TWO).

Continuous Data Protection (CDP)

Dynamic Data Masking

External Tokenization

Key pair authentication

Row access policies

Snowflake’s column level security features include Dynamic Data Masking and External Tokenization. Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.

NO.111 When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database. Reference: SnowPro Core Certification cloning database stored procedures views

NO.112 How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely

Until the result_cache expires

Until the retention_time is met

Until the expiration time is exceeded

NO.113 A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

No virtual warehouse will be used, data will be read from the result cache.

No virtual warehouse will be used, data will be read from the local disk cache.

The default virtual warehouse will be used to read all data.

The virtual warehouse that is defined at the session level will be used to read all data.

NO.114 Snowflake Documentation on Resource Monitors: Managing Resource Monitors QUSTION NO:600 What is a feature of column-level security in Snowflake?

Role access policies

Network policies

Internal tokenization

External tokenization

Column-level security in Snowflake is implemented through Role Access Policies. These policies allow administrators to control access to specific columns of a table or view based on the role of the user accessing the data. By applying a role access policy to a column, administrators can ensure that sensitive information remains secure, and only users with the appropriate roles can view or query the data in that column. This feature enhances the security model by providing fine-grained access control at the column level.
References:
Snowflake Documentation: Implementing Column-level Security

NO.115 Which constraint is enforced for standard Snowflake tables?

NOT NULL

PRIMARY KEY

FOREIGN KEY

UNIQUE

The correct answer is A. NOT NULL .
For standard Snowflake tables, Snowflake enforces the NOT NULL constraint. Other constraints such as PRIMARY KEY, FOREIGN KEY, and UNIQUE can be defined, but they are generally informational and are not enforced for standard tables.
Why A is correct:
A NOT NULL constraint prevents NULL values from being inserted into the constrained column.
Example:
CREATE TABLE customers (
customer_id NUMBER NOT NULL,
customer_name STRING
);
Why the other options are incorrect:
B). PRIMARY KEY constraints are not enforced for standard Snowflake tables.
C). FOREIGN KEY constraints are not enforced for standard Snowflake tables.
D). UNIQUE constraints are not enforced for standard Snowflake tables.
Official Snowflake documentation reference:
Snowflake documentation explains that for standard tables, NOT NULL constraints are enforced, while unique, primary key, and foreign key constraints are not enforced.
Reference: Snowflake Documentation – Constraints; Snowflake Documentation – Table constraints; SnowPro Core Study Guide – SQL and Snowflake Objects.

Loading …