Snowflake COF-C02 Practice Exams
Last updated on Oct 24,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 24,2026
Question #231
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?
- A . Use the SECURITYADMIN role.
- B . Use the SYSADMIN role.
- C . Use the USERADMIN role.
- D . Contact Snowflake Support.
Correct Answer: C
C
Explanation:
To temporarily bypass a network policy by configuring the user object property
MINS_TO_BYPASS_NETWORK_POLICY, the USERADMIN role should be used. This role has the necessary privileges to modify user properties, including setting a temporary bypass for network policies, which can be crucial for enabling access under specific circumstances without permanently altering the network security configuration.
References: Snowflake Documentation: User Management
C
Explanation:
To temporarily bypass a network policy by configuring the user object property
MINS_TO_BYPASS_NETWORK_POLICY, the USERADMIN role should be used. This role has the necessary privileges to modify user properties, including setting a temporary bypass for network policies, which can be crucial for enabling access under specific circumstances without permanently altering the network security configuration.
References: Snowflake Documentation: User Management
Question #232
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
- A . Removing a column from the query SELECT list
- B . Stopping the virtual warehouse that the query is running against
- C . Clustering of the data used by the query
- D . Executing the RESULTS_SCAN() table function
- E . Changing a column that is not in the cached query
Correct Answer: B, D
B, D
Explanation:
The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.
B, D
Explanation:
The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.
Question #233
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- A . Cloud Services
- B . Database Storage
- C . Query Processing
- D . Metadata Management
Correct Answer: B
B
Explanation:
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer. This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance
B
Explanation:
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer. This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance
Question #234
Which Snowflake table supports unstructured data?
- A . Directory
- B . Transient
- C . Temporary
- D . Permanent
Correct Answer: D
D
Explanation:
While Snowflake primarily deals with structured and semi-structured data, it also has the capability to handle unstructured data. Unstructured data can be stored in Snowflake using variants of SQL data types in tables, which can be permanent tables. These permanent tables, while traditionally used for structured or semi-structured data (like JSON, Avro, or Parquet), can also accommodate unstructured data in the form of binary formats or strings, offering flexibility in data storage and analysis.
However, the management and querying of unstructured data in Snowflake may require additional
considerations compared to structured data.
References: Snowflake Documentation on Data Types
D
Explanation:
While Snowflake primarily deals with structured and semi-structured data, it also has the capability to handle unstructured data. Unstructured data can be stored in Snowflake using variants of SQL data types in tables, which can be permanent tables. These permanent tables, while traditionally used for structured or semi-structured data (like JSON, Avro, or Parquet), can also accommodate unstructured data in the form of binary formats or strings, offering flexibility in data storage and analysis.
However, the management and querying of unstructured data in Snowflake may require additional
considerations compared to structured data.
References: Snowflake Documentation on Data Types
Question #235
Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
- A . ACCOUNTADMIN
- B . SECURITYADMIN
- C . SYSADMIN
- D . ORGADMIN
Correct Answer: A
A
Explanation:
The ACCOUNTADMIN role in Snowflake has the highest level of privileges, including the ability to manage accounts, users, roles, and all objects within the account. This role is specifically granted the permission to rename an account and specify whether the original URL can be used to access the renamed account. The ACCOUNTADMIN role encompasses broad administrative capabilities, ensuring that users assigned this role can perform critical account management tasks.
References: Snowflake Documentation on Roles and Permissions
A
Explanation:
The ACCOUNTADMIN role in Snowflake has the highest level of privileges, including the ability to manage accounts, users, roles, and all objects within the account. This role is specifically granted the permission to rename an account and specify whether the original URL can be used to access the renamed account. The ACCOUNTADMIN role encompasses broad administrative capabilities, ensuring that users assigned this role can perform critical account management tasks.
References: Snowflake Documentation on Roles and Permissions
Question #236
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running
Correct Answer: D
D
Explanation:
Snowflake credits are the unit of measure for the compute resources used in Snowflake. The number of credits consumed depends on the size of the virtual warehouse and the time it is running. Larger warehouses consume more credits per hour than smaller ones, and credits are billed for the time the warehouse is active, regardless of the actual usage within that time.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
D
Explanation:
Snowflake credits are the unit of measure for the compute resources used in Snowflake. The number of credits consumed depends on the size of the virtual warehouse and the time it is running. Larger warehouses consume more credits per hour than smaller ones, and credits are billed for the time the warehouse is active, regardless of the actual usage within that time.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #237
What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into <location> command used during data unloading? (Select TWO).
- A . Single quote character (‘)
- B . NULL
- C . ‘NULL’
- D . NONE
- E . ‘NONE’
Correct Answer: A, B
Question #238
How can staged files be removed during data loading once the files have loaded successfully?
- A . Use the DROP command
- B . Use the purge copy option.
- C . Use the FORCE = TRUE parameter
- D . Use the LOAD UNCERTAIN FILES copy option.
Correct Answer: B
B
Explanation:
To remove staged files during data loading after they have been successfully loaded, the PURGE copy option is used in Snowflake.
PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table.
Usage:
FROM @my_stage
FILE_FORMAT = (type = ‘csv’)
PURGE = TRUE;
References:
Snowflake Documentation on COPY INTO
B
Explanation:
To remove staged files during data loading after they have been successfully loaded, the PURGE copy option is used in Snowflake.
PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table.
Usage:
FROM @my_stage
FILE_FORMAT = (type = ‘csv’)
PURGE = TRUE;
References:
Snowflake Documentation on COPY INTO
Question #239
What is the MAXIMUM Time Travel retention period for a transient table?
- A . 0 days
- B . 1 day
- C . 7 days
- D . 90 days
Correct Answer: B
B
Explanation:
The maximum Time Travel retention period for a transient table in Snowflake is 1 day. This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.
B
Explanation:
The maximum Time Travel retention period for a transient table in Snowflake is 1 day. This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.
Question #240
How would you determine the size of the virtual warehouse used for a task?
- A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- B . Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- C . If using the stored procedure to execute multiple SQL statements, it’s best to test run the stored procedure separately to size the compute resource first
- D . Since task infrastructure is based on running the task body on schedule, it’s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Correct Answer: D
D
Explanation:
The size of the virtual warehouse for a task can be configured to handle concurrency automatically using a Multi-cluster warehouse (MCW). This is because tasks are designed to run their body on a schedule, and MCW allows for scaling compute resources to match the task’s execution needs without manual intervention.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
D
Explanation:
The size of the virtual warehouse for a task can be configured to handle concurrency automatically using a Multi-cluster warehouse (MCW). This is because tasks are designed to run their body on a schedule, and MCW allows for scaling compute resources to match the task’s execution needs without manual intervention.
References: [COF-C02] SnowPro Core Certification Exam Study Guide