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 #51
When cloning a schema, which Snowflake object will not be included in the clone?
- A . An external stage
- B . A named internal stage
- C . A task
- D . A User-Defined Function (UDF)
Correct Answer: A
Question #52
A materialized view should be created when which of the following occurs? (Choose two.)
- A . There is minimal cost associated with running the query.
- B . The query consumes many compute resources every time it runs.
- C . The base table gets updated frequently.
- D . The query is highly optimized and does not consume many compute resources.
- E . The results of the query do not change often and are used frequently.
Correct Answer: B, E
B, E
Explanation:
A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E). This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex
B, E
Explanation:
A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E). This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex
Question #53
Which object can be used with Secure Data Sharing?
- A . View
- B . Materialized view
- C . External table
- D . User-Defined Function (UDF)
Correct Answer: A
A
Explanation:
Views can be used with Secure Data Sharing in Snowflake. Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.
A
Explanation:
Views can be used with Secure Data Sharing in Snowflake. Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.
Question #54
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
- A . CREATE TABLE <table_name> LIKE TABLE_A;
- B . CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
- C . CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
- D . CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
Correct Answer: C
C
Explanation:
When a tag object is assigned to a table, using the statement CREATE TABLE <table_name> AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.
C
Explanation:
When a tag object is assigned to a table, using the statement CREATE TABLE <table_name> AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.
Question #55
Which of the following describes how clustering keys work in Snowflake?
- A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- B . Clustering keys sort the designated columns over time, without blocking DML operations
- C . Clustering keys create a distributed, parallel data structure of pointers to a table’s rows and columns
- D . Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Correct Answer: B
B
Explanation:
Clustering keys in Snowflake work by sorting the designated columns over time. This process is done in the background and does not block data manipulation language (DML) operations, allowing for normal database operations to continue without interruption. The purpose of clustering keys is to organize the data within micro-partitions to optimize query performance1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Clustering1
B
Explanation:
Clustering keys in Snowflake work by sorting the designated columns over time. This process is done in the background and does not block data manipulation language (DML) operations, allowing for normal database operations to continue without interruption. The purpose of clustering keys is to organize the data within micro-partitions to optimize query performance1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Clustering1
Question #56
Snowflake’s hierarchical key mode includes which keys? (Select TWO).
- A . Account master keys
- B . Database master keys
- C . File keys
- D . Secure view keys
- E . Schema master keys
Correct Answer: A, C
A, C
Explanation:
Snowflake’s hierarchical key model includes several levels of keys, where Account master keys and File keys are part of this hierarchy. Account master keys are used to encrypt all the data within an account, while File keys are used to encrypt individual files within the database2.
A, C
Explanation:
Snowflake’s hierarchical key model includes several levels of keys, where Account master keys and File keys are part of this hierarchy. Account master keys are used to encrypt all the data within an account, while File keys are used to encrypt individual files within the database2.
Question #57
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A . A read-only copy of the cloned tables is stored.
- B . The replication will not be successful.
- C . The physical data is replicated
- D . Additional costs for storage are charged to a secondary account
- E . Metadata pointers to cloned tables are replicated
Correct Answer: C, E
C, E
Explanation:
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 the secondary 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.
References:
SnowPro Core Exam Prep ― Answers to Snowflake’s LEVEL UP: Backup and Recovery Snowflake SnowPro Core Certification Exam Questions Set 10
C, E
Explanation:
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 the secondary 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.
References:
SnowPro Core Exam Prep ― Answers to Snowflake’s LEVEL UP: Backup and Recovery Snowflake SnowPro Core Certification Exam Questions Set 10
Question #58
What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries by offloading portions of the query processing work to shared compute resources?
- A . Using a multi-cluster virtual warehouse
- B . Using the query acceleration service
- C . Using the search optimization service
- D . Disabling auto-suspend
Correct Answer: B
Question #59
Which of the following describes a Snowflake stored procedure?
- A . They can be created as secure and hide the underlying metadata from the user.
- B . They can only access tables from a single database.
- C . They can contain only a single SQL statement.
- D . They can be created to run with a caller’s rights or an owner’s rights.
Correct Answer: D
D
Explanation:
Snowflake stored procedures can be created to execute with the privileges of the role that owns the procedure (owner’s rights) or with the privileges of the role that calls the procedure (caller’s rights). This allows for flexibility in managing security and access control within Snowflake1.
D
Explanation:
Snowflake stored procedures can be created to execute with the privileges of the role that owns the procedure (owner’s rights) or with the privileges of the role that calls the procedure (caller’s rights). This allows for flexibility in managing security and access control within Snowflake1.
Question #60
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
- A . PURGE
- B . MODIFY
- C . REMOVE
- D . DELETE
Correct Answer: C
C
Explanation:
The SQL command used to delete files from a Snowflake internal stage is REMOVE. This command can be used to remove files from either an internal or external stage within Snowflake
C
Explanation:
The SQL command used to delete files from a Snowflake internal stage is REMOVE. This command can be used to remove files from either an internal or external stage within Snowflake