Snowflake COF-C02 Practice Exams
Last updated on Oct 23,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 23,2026
Question #141
Which features are included in Snowsight? (Select TWO)
- A . Worksheet sharing
- B . Referencing SnowSQL
- C . Exploring the Snowflake Marketplace
- D . Changing the Snowflake account cloud provider
- E . Downloading query result data larger than 100 MB
Correct Answer: A, C
Question #142
Which Query Profile operator is considered a DML operator?
- A . ExternalScan
- B . Flatten
- C . Merge
- D . Sort
Correct Answer: C
C
Explanation:
The Merge operator is considered a DML (Data Manipulation Language) operator in Snowflake. DML operators are used to modify data in tables, and the Merge operator specifically allows for conditional updates, inserts, or deletes in a target table based on the results of a join with a source table.
References:
Snowflake Documentation: Query Profile Overview
Snowflake Documentation: MERGE Statement
C
Explanation:
The Merge operator is considered a DML (Data Manipulation Language) operator in Snowflake. DML operators are used to modify data in tables, and the Merge operator specifically allows for conditional updates, inserts, or deletes in a target table based on the results of a join with a source table.
References:
Snowflake Documentation: Query Profile Overview
Snowflake Documentation: MERGE Statement
Question #143
Which feature is only available in the Enterprise or higher editions of Snowflake?
- A . Column-level security
- B . SOC 2 type II certification
- C . Multi-factor Authentication (MFA)
- D . Object-level access control
Correct Answer: A
A
Explanation:
Column-level security is a feature that allows fine-grained control over access to specific columns within a table. This is particularly useful for managing sensitive data and ensuring that only authorized users can view or manipulate certain pieces of information. According to my last update, this feature was available in the Enterprise Edition or higher editions of Snowflake.
References: Based on my internal data as of 2021, column-level security is an advanced feature typically reserved for higher-tiered editions like the Enterprise Edition in data warehousing solutions such as Snowflake.
https://docs.snowflake.com/en/user-guide/intro-editions.html
A
Explanation:
Column-level security is a feature that allows fine-grained control over access to specific columns within a table. This is particularly useful for managing sensitive data and ensuring that only authorized users can view or manipulate certain pieces of information. According to my last update, this feature was available in the Enterprise Edition or higher editions of Snowflake.
References: Based on my internal data as of 2021, column-level security is an advanced feature typically reserved for higher-tiered editions like the Enterprise Edition in data warehousing solutions such as Snowflake.
https://docs.snowflake.com/en/user-guide/intro-editions.html
Question #144
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
- A . The temporary table will take precedence over the permanent table.
- B . The permanent table will take precedence over the temporary table.
- C . An error will say there cannot be two tables with the same name in a schema.
- D . The table that was created most recently will take precedence over the older table.
Correct Answer: A
A
Explanation:
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.
A
Explanation:
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.
Question #145
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
- A . Directory
- B . File
- C . Pre-signed
- D . Scoped
Correct Answer: C
C
Explanation:
The pre-signed URL type allows users or applications to download or access files directly from a Snowflake stage without authentication. This URL type is open and can be used without needing to authenticate into Snowflake or pass an authorization token.
C
Explanation:
The pre-signed URL type allows users or applications to download or access files directly from a Snowflake stage without authentication. This URL type is open and can be used without needing to authenticate into Snowflake or pass an authorization token.
Question #146
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A . Via the Snowflake Web Interface (Ul)
- B . Via the data_share=true parameter
- C . Via SQL commands
- D . Via Virtual Warehouses
Correct Answer: A, C
A, C
Explanation:
In Snowflake, Data Shares can be created and managed in two primary ways:
Via the Snowflake Web Interface (UI): Users can create and manage shares through the graphical interface provided by Snowflake, which allows for a user-friendly experience.
Via SQL commands: Snowflake also allows the creation and management of shares using SQL commands. This method is more suited for users who prefer scripting or need to automate the process.
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
A, C
Explanation:
In Snowflake, Data Shares can be created and managed in two primary ways:
Via the Snowflake Web Interface (UI): Users can create and manage shares through the graphical interface provided by Snowflake, which allows for a user-friendly experience.
Via SQL commands: Snowflake also allows the creation and management of shares using SQL commands. This method is more suited for users who prefer scripting or need to automate the process.
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
Question #147
What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO).
- A . A count of the number of total values in the micro-partition
- B . The range of values for each partition in the micro-partition
- C . The range of values for each of the rows in the micro-partition
- D . The range of values for each of the columns in the micro-partition
- E . The number of distinct values for each column in the micro-partition
Correct Answer: A, D
Question #148
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
- A . Tri-Secret Secure
- B . Time Travel
- C . Fail-safe
- D . Data encryption
- E . External stages
Correct Answer: B, C
B, C
Explanation:
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
B, C
Explanation:
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #149
What is the purpose of the Snowflake SPLIT TO_TABLE function?
- A . To count the number of characters in a string
- B . To split a string into an array of sub-strings
- C . To split a string and flatten the results into rows
- D . To split a string and flatten the results into columns
Correct Answer: C
C
Explanation:
The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows. This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.
C
Explanation:
The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows. This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.
Question #150
What data is stored in the Snowflake storage layer? (Select TWO).
- A . Snowflake parameters
- B . Micro-partitions
- C . Query history
- D . Persisted query results
- E . Standard and secure view results
Correct Answer: B, D
B, D
Explanation:
The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes micro-partitions, which are the fundamental storage units that contain the actual data stored in Snowflake. Additionally, persisted query results, which are the results of queries that have been materialized and stored for future use, are also kept within this layer. This design allows for efficient data retrieval and management within the Snowflake architecture1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Key Concepts & Architecture | Snowflake Documentation2
B, D
Explanation:
The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes micro-partitions, which are the fundamental storage units that contain the actual data stored in Snowflake. Additionally, persisted query results, which are the results of queries that have been materialized and stored for future use, are also kept within this layer. This design allows for efficient data retrieval and management within the Snowflake architecture1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Key Concepts & Architecture | Snowflake Documentation2