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 #61
Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
- A . Java
- B . Javascript
- C . Scala
- D . Python
- E . SQL
Correct Answer: B, E
B, E
Explanation:
User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.
B, E
Explanation:
User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.
Question #62
Which command can be performed on a Snowflake secure view?
- A . SELECT
- B . INSERT
- C . UPDATE
- D . DELETE
Correct Answer: B
Question #63
What is the MOST performant file format for loading data in Snowflake?
- A . CSV (Unzipped)
- B . Parquet
- C . CSV (Gzipped)
- D . ORC
Correct Answer: B
B
Explanation:
Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, which can lead to significant savings in storage and speed in query processing, making it the most performant file format for loading data into Snowflake.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Loading1
B
Explanation:
Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, which can lead to significant savings in storage and speed in query processing, making it the most performant file format for loading data into Snowflake.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Loading1
Question #64
Which statements reflect valid commands when using secondary roles? (Select TWO).
- A . Use SECONDARY ROLES RESUME
- B . USE SECONDARY ROLES SUSPEND
- C . USE SECONDARY RLES ALL
- D . USE SECONDARY ROLES ADD <Role Name>
- E . Use SECONDARY ROLES NONE
Correct Answer: CE
CE
Explanation:
USE SECONDARY ROLES ALL: Activates all granted secondary roles for the current session.
USE SECONDARY ROLES NONE: Deactivates all active secondary roles for the current session.
Incorrect Commands: The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
Snowflake Documentation (USE SECONDARY ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
CE
Explanation:
USE SECONDARY ROLES ALL: Activates all granted secondary roles for the current session.
USE SECONDARY ROLES NONE: Deactivates all active secondary roles for the current session.
Incorrect Commands: The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
Snowflake Documentation (USE SECONDARY ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
Question #65
What is a characteristic of the Snowflake Query Profile?
- A . It can provide statistics on a maximum number of 100 queries per week.
- B . It provides a graphic representation of the main components of the query processing.
- C . It provides detailed statistics about which queries are using the greatest number of compute resources.
- D . It can be used by third-party software using the Query Profile API.
Correct Answer: B
B
Explanation:
The Snowflake Query Profile provides a graphic representation of the main components of the query processing. This visual aid helps users understand the execution details and performance characteristics of their queries4.
B
Explanation:
The Snowflake Query Profile provides a graphic representation of the main components of the query processing. This visual aid helps users understand the execution details and performance characteristics of their queries4.
Question #66
Which privilege is required on a virtual warehouse to abort any existing executing queries?
- A . USAGE
- B . OPERATE
- C . MODIFY
- D . MONITOR
Correct Answer: B
B
Explanation:
The privilege required on a virtual warehouse to abort any existing executing queries is OPERATE. The OPERATE privilege on a virtual warehouse allows a user to perform operational tasks on the warehouse, including starting, stopping, and restarting the warehouse, as well as aborting running queries. This level of control is essential for managing resource utilization and ensuring that the virtual warehouse operates efficiently.
References: Snowflake Documentation on Access Control: Access Control Privileges
B
Explanation:
The privilege required on a virtual warehouse to abort any existing executing queries is OPERATE. The OPERATE privilege on a virtual warehouse allows a user to perform operational tasks on the warehouse, including starting, stopping, and restarting the warehouse, as well as aborting running queries. This level of control is essential for managing resource utilization and ensuring that the virtual warehouse operates efficiently.
References: Snowflake Documentation on Access Control: Access Control Privileges
Question #67
What Snowflake role must be granted for a user to create and manage accounts?
- A . ACCOUNTADMIN
- B . ORGADMIN
- C . SECURITYADMIN
- D . SYSADMIN
Correct Answer: A
A
Explanation:
The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake. This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
A
Explanation:
The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake. This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Question #68
Which Snowflake object does not consume any storage costs?
- A . Secure view
- B . Materialized view
- C . Temporary table
- D . Transient table
Correct Answer: C
C
Explanation:
Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges4.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
C
Explanation:
Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges4.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #69
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
- A . The user has the appropriate privileges on the objects associated with the query
- B . Micro-partitions have been reclustered since the query was last run
- C . The new query is run using the same virtual warehouse as the previous query
- D . The query includes a User Defined Function (UDF)
- E . The query has been run within 24 hours of the previously-run query
Correct Answer: A, E
A, E
Explanation:
To return results from the results cache in Snowflake, certain conditions must be met:
Privileges: The user must have the appropriate privileges on the objects associated with the query.
This ensures that only authorized users can access cached data.
Time Frame: The query must have been run within 24 hours of the previously-run query. Snowflake’s results cache is designed to store the results of queries for a short period, typically 24 hours, to improve performance for repeated queries.
A, E
Explanation:
To return results from the results cache in Snowflake, certain conditions must be met:
Privileges: The user must have the appropriate privileges on the objects associated with the query.
This ensures that only authorized users can access cached data.
Time Frame: The query must have been run within 24 hours of the previously-run query. Snowflake’s results cache is designed to store the results of queries for a short period, typically 24 hours, to improve performance for repeated queries.
Question #70
Which role must be used to create resource monitors?
- A . SECURITYADMIN
- B . ACCOUNTADMIN
- C . SYSADMIN
- D . ORGADMIN
Correct Answer: B
B
Explanation:
In Snowflake, the ACCOUNTADMIN role is required to create resource monitors. Resource monitors are used to manage and monitor the consumption of compute resources. The ACCOUNTADMIN role has the necessary privileges to create, configure, and manage resource monitors across the account.
References: Snowflake Documentation: Resource Monitors
B
Explanation:
In Snowflake, the ACCOUNTADMIN role is required to create resource monitors. Resource monitors are used to manage and monitor the consumption of compute resources. The ACCOUNTADMIN role has the necessary privileges to create, configure, and manage resource monitors across the account.
References: Snowflake Documentation: Resource Monitors