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 #21
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
- A . USAGE on the specific tables in the database.
- B . USAGE on the specific tables in the database.
- C . MODIFY on 1Mb specific tables in the database.
- D . USAGE on the database and the schema containing the tables to share
- E . OPEBATE on the database and the schema containing the tables to share.
Correct Answer: A, D
A, D
Explanation:
When sharing data in Snowflake, the provider needs to grant the following privileges along with a share:
A, D
Explanation:
When sharing data in Snowflake, the provider needs to grant the following privileges along with a share:
Question #22
To use the overwrite option on insert, which privilege must be granted to the role?
- A . truncate
- B . DELETE
- C . UPDATE
- D . SELECT
Correct Answer: B
B
Explanation:
To use the overwrite option on insert in Snowflake, the DELETE privilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data.
Understanding the Overwrite Option: The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed.
Why DELETE Privilege is Required: Since the overwrite operation involves removing existing rows in the table, the executing role must have the DELETE privilege to carry out both the deletion of old data and the insertion of new data.
Granting DELETE Privilege:
To grant the DELETE privilege to a role, an account administrator can execute the following SQL command:
sqlCopy code
GRANT DELETE ON TABLE my_table TO ROLE my_role;
Reference: For additional details on inserting data with the overwrite option and the required privileges, consult the Snowflake documentation on data loading: https://docs.snowflake.com/en/sql-reference/sql/insert.html
B
Explanation:
To use the overwrite option on insert in Snowflake, the DELETE privilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data.
Understanding the Overwrite Option: The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed.
Why DELETE Privilege is Required: Since the overwrite operation involves removing existing rows in the table, the executing role must have the DELETE privilege to carry out both the deletion of old data and the insertion of new data.
Granting DELETE Privilege:
To grant the DELETE privilege to a role, an account administrator can execute the following SQL command:
sqlCopy code
GRANT DELETE ON TABLE my_table TO ROLE my_role;
Reference: For additional details on inserting data with the overwrite option and the required privileges, consult the Snowflake documentation on data loading: https://docs.snowflake.com/en/sql-reference/sql/insert.html
Question #23
Who can grant object privileges in a regular schema?
- A . Object owner
- B . Schema owner
- C . Database owner
- D . SYSADMIN
Correct Answer: A
A
Explanation:
In a regular schema within Snowflake, the object owner has the privilege to grant object
privileges. The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.
References = [COF-C02] SnowPro Core Certification Exam Study Guide
A
Explanation:
In a regular schema within Snowflake, the object owner has the privilege to grant object
privileges. The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.
References = [COF-C02] SnowPro Core Certification Exam Study Guide
Question #24
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
- A . Data classification
- B . Query acceleration service
- C . Search optimization service
- D . Tagging
Correct Answer: C
C
Explanation:
The Search Optimization Service in Snowflake is designed to improve the performance of specific types of queries, particularly those involving extensive sets of WHERE conditions. By maintaining a search index on tables, this service can accelerate lookup and analytical queries, making it a valuable feature for optimizing query performance and reducing execution times for complex searches.
References: Snowflake Documentation: Search Optimization Service
C
Explanation:
The Search Optimization Service in Snowflake is designed to improve the performance of specific types of queries, particularly those involving extensive sets of WHERE conditions. By maintaining a search index on tables, this service can accelerate lookup and analytical queries, making it a valuable feature for optimizing query performance and reducing execution times for complex searches.
References: Snowflake Documentation: Search Optimization Service
Question #25
Which function is used to convert rows in a relational table to a single VARIANT column?
- A . ARRAY_AGG
- B . OBJECT_AGG
- C . ARRAY_CONSTRUCT
- D . OBJECT_CONSTRUCT
Correct Answer: D
D
Explanation:
The OBJECT_CONSTRUCT function in Snowflake is used to convert rows in a relational table into a single VARIANT column that represents each row as a JSON object. This function dynamically creates a JSON object from a list of key-value pairs, where each key is a column name and each value is the corresponding column value for a row. This is particularly useful for aggregating and transforming structured data into semi-structured JSON format for further processing or analysis.
References: Snowflake Documentation: Semi-structured Data Functions
D
Explanation:
The OBJECT_CONSTRUCT function in Snowflake is used to convert rows in a relational table into a single VARIANT column that represents each row as a JSON object. This function dynamically creates a JSON object from a list of key-value pairs, where each key is a column name and each value is the corresponding column value for a row. This is particularly useful for aggregating and transforming structured data into semi-structured JSON format for further processing or analysis.
References: Snowflake Documentation: Semi-structured Data Functions
Question #26
When retrieving data from a table which type of query will benefit the MOST from use of the search optimization service?
- A . Queries with unpredictable data volumes.
- B . Queries with highly-selective table filters that return a small subset of rows.
- C . Queries on fields in a VARIANT column that will return all data as structured data.
- D . Queries that involve one or more columns inside the cluster key using the lowest cardinality to select filters.
Correct Answer: C
Question #27
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
- A . Schema
- B . View
- C . Internal stage
- D . Table
- E . User
- F . Role
Correct Answer: B, D
B, D
Explanation:
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a ‘Recycle Bin’ where they can be restored within a time limit before they are permanently deleted.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
B, D
Explanation:
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a ‘Recycle Bin’ where they can be restored within a time limit before they are permanently deleted.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #28
At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
- A . Account
- B . Database
- C . Schema
- D . Table
Correct Answer: A
A
Explanation:
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter is set at the Account level in Snowflake. This parameter specifies the minimum number of days Snowflake retains the historical data for time travel, which allows users to access and query data as it existed at previous points in time.
Here’s how to understand and adjust this parameter:
Purpose of MIN_DATA_RETENTION_TIME_IN_DAYS: This parameter is crucial for managing data lifecycle and compliance requirements within Snowflake. It determines the minimum time frame for which you can perform operations like restoring deleted objects or accessing historical versions of data.
Setting the Parameter: Only account administrators can set or modify this parameter. It is done at the account level, impacting all databases and schemas within the account. The setting can be adjusted based on the organization’s data retention policy.
Adjusting the Parameter:
To view the current setting, use:
SHOW PARAMETERS LIKE ‘MIN_DATA_RETENTION_TIME_IN_DAYS’; To change the setting, an account administrator can execute:
ALTER ACCOUNT SET MIN_DATA_RETENTION_TIME_IN_DAYS = <number_of_days>; Reference: For more details on data retention and time travel in Snowflake, refer to the official documentation: https://docs.snowflake.com/en/sql-reference/account-usage/storage-usage.html#data-retention-time-travel
A
Explanation:
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter is set at the Account level in Snowflake. This parameter specifies the minimum number of days Snowflake retains the historical data for time travel, which allows users to access and query data as it existed at previous points in time.
Here’s how to understand and adjust this parameter:
Purpose of MIN_DATA_RETENTION_TIME_IN_DAYS: This parameter is crucial for managing data lifecycle and compliance requirements within Snowflake. It determines the minimum time frame for which you can perform operations like restoring deleted objects or accessing historical versions of data.
Setting the Parameter: Only account administrators can set or modify this parameter. It is done at the account level, impacting all databases and schemas within the account. The setting can be adjusted based on the organization’s data retention policy.
Adjusting the Parameter:
To view the current setting, use:
SHOW PARAMETERS LIKE ‘MIN_DATA_RETENTION_TIME_IN_DAYS’; To change the setting, an account administrator can execute:
ALTER ACCOUNT SET MIN_DATA_RETENTION_TIME_IN_DAYS = <number_of_days>; Reference: For more details on data retention and time travel in Snowflake, refer to the official documentation: https://docs.snowflake.com/en/sql-reference/account-usage/storage-usage.html#data-retention-time-travel
Question #29
Which objects together comprise a namespace in Snowflake? (Select TWO).
- A . Account
- B . Database
- C . Schema
- D . Table
- E . Virtual warehouse
Correct Answer: B, C
B, C
Explanation:
In Snowflake, a namespace is comprised of a database and a schema. The combination of a database and schema uniquely identifies database objects within an account
B, C
Explanation:
In Snowflake, a namespace is comprised of a database and a schema. The combination of a database and schema uniquely identifies database objects within an account
Question #30
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
- A . Scale-up by resizing the warehouse.
- B . Scale-out with a multi-cluster warehouse.
- C . Disable auto-suspend on the warehouse.
- D . Enable auto-resume on the warehouse.
Correct Answer: A