Snowflake COF-C02 Practice Exams
Last updated on Oct 22,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 22,2026
Question #31
The customer table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? {Select TWO).
- A . SELECT privilege on the customer table
- B . ownership privilege on the customer table
- C . All privileges on the customer table
- D . All privileges on the T1 database
- E . CREATE TABIE privilege on the T1 database
Correct Answer: D, E
Question #32
Which minimum Snowflake edition allows for a dedicated metadata store?
- A . Standard
- B . Enterprise
- C . Business Critical
- D . Virtual Private Snowflake
Correct Answer: B
B
Explanation:
The Enterprise edition of Snowflake allows for a dedicated metadata store, providing additional features designed for large-scale enterprises
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
B
Explanation:
The Enterprise edition of Snowflake allows for a dedicated metadata store, providing additional features designed for large-scale enterprises
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question #33
Which objects will incur storage costs associated with Fail-safe?
- A . External tables
- B . Permanent tables
- C . Data files available in internal stages
- D . Data files available in external stages
Correct Answer: D
D
Explanation:
Snowflake’s Data Exchange allows users to create and manage a group of accounts to which they can offer data shares. This platform facilitates secure and governed data sharing within and between organizations.
Data Exchange Setup: Users can set up a Data Exchange and invite other Snowflake accounts to join.
Sharing Data: Within the Data Exchange, users can offer shares to the entire group or to specific accounts.
Governance and Security: Data Exchange provides tools for data governance and security, ensuring that shared data is only accessible to authorized accounts.
References:
Snowflake Documentation: Snowflake Data Exchange
Snowflake Documentation: Managing a Data Exchange
D
Explanation:
Snowflake’s Data Exchange allows users to create and manage a group of accounts to which they can offer data shares. This platform facilitates secure and governed data sharing within and between organizations.
Data Exchange Setup: Users can set up a Data Exchange and invite other Snowflake accounts to join.
Sharing Data: Within the Data Exchange, users can offer shares to the entire group or to specific accounts.
Governance and Security: Data Exchange provides tools for data governance and security, ensuring that shared data is only accessible to authorized accounts.
References:
Snowflake Documentation: Snowflake Data Exchange
Snowflake Documentation: Managing a Data Exchange
Question #34
Which type of role can be granted to a share?
- A . Account role
- B . Custom role
- C . Database role
- D . Secondary role
Correct Answer: B
B
Explanation:
In Snowflake, shares are used to share data between Snowflake accounts. When creating a share, it is possible to grant access to the share to roles within the Snowflake account that is creating the share. The type of role that can be granted to a share is a Custom role. Custom roles are user-defined roles that account administrators can create to manage access control in a more granular way. Unlike predefined roles such as ACCOUNTADMIN or SYSADMIN, custom roles can be tailored with specific privileges to meet the security and access requirements of different groups within an organization.
Granting a custom role access to a share enables users associated with that role to access the shared data if the share is received by another Snowflake account. It is important to carefully manage the privileges granted to custom roles to ensure that data sharing aligns with organizational policies and data governance standards.
References:
Snowflake Documentation on Shares: Shares
Snowflake Documentation on Roles: Access Control
B
Explanation:
In Snowflake, shares are used to share data between Snowflake accounts. When creating a share, it is possible to grant access to the share to roles within the Snowflake account that is creating the share. The type of role that can be granted to a share is a Custom role. Custom roles are user-defined roles that account administrators can create to manage access control in a more granular way. Unlike predefined roles such as ACCOUNTADMIN or SYSADMIN, custom roles can be tailored with specific privileges to meet the security and access requirements of different groups within an organization.
Granting a custom role access to a share enables users associated with that role to access the shared data if the share is received by another Snowflake account. It is important to carefully manage the privileges granted to custom roles to ensure that data sharing aligns with organizational policies and data governance standards.
References:
Snowflake Documentation on Shares: Shares
Snowflake Documentation on Roles: Access Control
Question #35
Which table function will return the output of a previously-run command?
- A . FLATTEN
- B . QUERY_HISTORY
- C . TASK_HISTORY
- D . RESULT_SCAN
Correct Answer: C
Question #36
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A . Pipe
- B . External stage
- C . Task
- D . Stream
Correct Answer: A
A
Explanation:
In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as soon as they are available in a cloud storage location. Pipes use
Snowflake’s COPY command to load data and can be associated with a Stage object to monitor for new files. When new data files appear in the stage, the pipe automatically loads the data into the target table.
References:
Snowflake Documentation on Pipes
SnowPro® Core Certification Study Guide
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
A
Explanation:
In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as soon as they are available in a cloud storage location. Pipes use
Snowflake’s COPY command to load data and can be associated with a Stage object to monitor for new files. When new data files appear in the stage, the pipe automatically loads the data into the target table.
References:
Snowflake Documentation on Pipes
SnowPro® Core Certification Study Guide
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Question #37
Which views are included in the data_sharing_usage schema? (Select TWO).
- A . ACCESS_HISTORY
- B . DATA_TRANSFER_HISTORY
- C . WAREHOUSE_METERING_HISTORY
- D . MONETIZED_USAGE_DAILY
- E . LISTING TELEMETRY DAILY
Correct Answer: DE
DE
Explanation:
https://docs.snowflake.com/en/sql-reference/data-sharing-usage
DE
Explanation:
https://docs.snowflake.com/en/sql-reference/data-sharing-usage
Question #38
Which command is used to remove files from either external cloud storage or an internal staged
- A . DELETE
- B . REMOVE
- C . TRUNCATE
- D . DROP
Correct Answer: B
B
Explanation:
The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage costs.
References: Snowflake Documentation: REMOVE Command
B
Explanation:
The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage costs.
References: Snowflake Documentation: REMOVE Command
Question #39
Which of the following can be executed/called with Snowpipe?
- A . A User Defined Function (UDF)
- B . A stored procedure
- C . A single copy_into statement
- D . A single insert__into statement
Correct Answer: C
C
Explanation:
Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements.
References: Snowpipe | Snowflake Documentation
C
Explanation:
Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements.
References: Snowpipe | Snowflake Documentation
Question #40
What is the primary purpose of using a masking policy in Snowflake?
- A . To protect sensitive data from unauthorized access when queries are run.
- B . To automatically encrypt sensitive data when data is stored in Snowflake.
- C . To protect multiple columns that have different data types in a given table.
- D . To protect both column-level and row-level data.
Correct Answer: A
A
Explanation:
Masking policies in Snowflake are designed to protect sensitive information by dynamically hiding or obfuscating data based on the role of the user executing the query. This helps enforce data privacy and security by allowing only authorized users to see sensitive information. Masking policies do not encrypt data but apply rules to limit data visibility, ensuring sensitive data is protected during query execution without altering the underlying data.
A
Explanation:
Masking policies in Snowflake are designed to protect sensitive information by dynamically hiding or obfuscating data based on the role of the user executing the query. This helps enforce data privacy and security by allowing only authorized users to see sensitive information. Masking policies do not encrypt data but apply rules to limit data visibility, ensuring sensitive data is protected during query execution without altering the underlying data.