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 #211
Which of the following objects can be shared through secure data sharing?
- A . Masking policy
- B . Stored procedure
- C . Task
- D . External table
Correct Answer: D
D
Explanation:
Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
References:
Snowflake Documentation on Secure Data Sharing
SnowPro™ Core Certification Companion: Hands-on Preparation and Practice
D
Explanation:
Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
References:
Snowflake Documentation on Secure Data Sharing
SnowPro™ Core Certification Companion: Hands-on Preparation and Practice
Question #212
What happens when a Snowflake user changes the data retention period at the schema level?
- A . All child objects will retain data for the new retention period.
- B . All child objects that do not have an explicit retention period will automatically inherit the new retention period.
- C . All child objects with an explicit retention period will be overridden with the new retention period.
- D . All explicit child object retention periods will remain unchanged.
Correct Answer: B
B
Explanation:
When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.
B
Explanation:
When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.
Question #213
For Directory tables, what stage allows for automatic refreshing of metadata?
- A . User stage
- B . Table stage
- C . Named internal stage
- D . Named external stage
Correct Answer: D
D
Explanation:
For directory tables, a named external stage allows for the automatic refreshing of metadata. This capability is particularly useful when dealing with files stored on external storage services (like Amazon S3, Google Cloud Storage, or Azure Blob Storage) and accessed through Snowflake. The external stage references these files, and the directory table’s metadata can be automatically updated to reflect changes in the underlying files.
References: Snowflake Documentation: External Stages
D
Explanation:
For directory tables, a named external stage allows for the automatic refreshing of metadata. This capability is particularly useful when dealing with files stored on external storage services (like Amazon S3, Google Cloud Storage, or Azure Blob Storage) and accessed through Snowflake. The external stage references these files, and the directory table’s metadata can be automatically updated to reflect changes in the underlying files.
References: Snowflake Documentation: External Stages
Question #214
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.
What will happen at the 2< hour mark?
- A . The file will continue to load until all contents arc loaded.
- B . The tile will slop loading and all data up to that point will be committed.
- C . The file loading could be aborted without any portion of the file being committed.
- D . The file’s number of allowable hours to load can be programmatically controlled to load easily into Snowflake
Correct Answer: C
C
Explanation:
When attempting to load large files, such as a 125 GB file, into Snowflake using SnowSQL, the process might encounter limitations related to the maximum execution time for queries or data loading operations. If the loading process exceeds this time limit (typically around 24 hours), it could be aborted without committing any part of the file to the database. This behavior is designed to prevent indefinite resource consumption and to maintain system stability, emphasizing the need for optimizing data load operations, possibly through file segmentation or parallel loading strategies.
References: Snowflake Documentation on Data Loading Considerations
C
Explanation:
When attempting to load large files, such as a 125 GB file, into Snowflake using SnowSQL, the process might encounter limitations related to the maximum execution time for queries or data loading operations. If the loading process exceeds this time limit (typically around 24 hours), it could be aborted without committing any part of the file to the database. This behavior is designed to prevent indefinite resource consumption and to maintain system stability, emphasizing the need for optimizing data load operations, possibly through file segmentation or parallel loading strategies.
References: Snowflake Documentation on Data Loading Considerations
Question #215
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
- A . Auto-scale mode
- B . Maximized mode
- C . Economy scaling policy
- D . Standard scaling policy
Correct Answer: A
A
Explanation:
In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode. This mode allows Snowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases
A
Explanation:
In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode. This mode allows Snowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases
Question #216
If a virtual warehouse is suspended, what happens to the warehouse cache?
- A . The cache is dropped when the warehouse is suspended and is no longer available upon restart.
- B . The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
- C . The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
- D . The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.
Correct Answer: A
A
Explanation:
When a virtual warehouse in Snowflake is suspended, the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active.
Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.
A
Explanation:
When a virtual warehouse in Snowflake is suspended, the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active.
Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.
Question #217
Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).
A)
B)
C)
D)
E)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
- E . Option E
Correct Answer: A
Question #218
At what levels can a resource monitor be configured? (Select TWO).
- A . Account
- B . Database
- C . Organization
- D . Schema
- E . Virtual warehouse
Correct Answer: A, E
A, E
Explanation:
Resource monitors in Snowflake can be configured at the account and virtual warehouse levels. They are used to track credit usage and control costs associated with running virtual warehouses. When certain thresholds are reached, resource monitors can trigger actions such as sending alerts or suspending warehouses to prevent excessive credit consumption.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
A, E
Explanation:
Resource monitors in Snowflake can be configured at the account and virtual warehouse levels. They are used to track credit usage and control costs associated with running virtual warehouses. When certain thresholds are reached, resource monitors can trigger actions such as sending alerts or suspending warehouses to prevent excessive credit consumption.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #219
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
- A . 1 minutes
- B . 5 minutes
- C . 10 minutes
- D . 15 minutes
Correct Answer: C
C
Explanation:
The default value for auto-suspending a Virtual Warehouse in the Snowflake Web Interface (UI) is 10 minutes. This setting helps manage compute costs by automatically suspending warehouses that are not in use, ensuring that compute resources are efficiently allocated and not wasted on idle warehouses.
References:
Snowflake Documentation: Virtual Warehouses
C
Explanation:
The default value for auto-suspending a Virtual Warehouse in the Snowflake Web Interface (UI) is 10 minutes. This setting helps manage compute costs by automatically suspending warehouses that are not in use, ensuring that compute resources are efficiently allocated and not wasted on idle warehouses.
References:
Snowflake Documentation: Virtual Warehouses
Question #220
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
- A . Use Snowpipe.
- B . Use the INSERT command.
- C . Use an external table.
- D . Use the COPY command.
Correct Answer: D
D
Explanation:
Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage. This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.
D
Explanation:
Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage. This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.