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 #151
What is the name of the SnowSQLfile that can store connection information?
- A . history
- B . config
- C . snowsqLcnf
- D . snowsql.pubkey
Correct Answer: B
B
Explanation:
The SnowSQL file that can store connection information is named ‘config’. It is used to store user credentials and connection details for easy access to Snowflake instances.
References: Based on general database knowledge as of 2021.
B
Explanation:
The SnowSQL file that can store connection information is named ‘config’. It is used to store user credentials and connection details for easy access to Snowflake instances.
References: Based on general database knowledge as of 2021.
Question #152
Which command is used to unload files from an internal or external stage to a local file system?
- A . COPY INTO
- B . GET
- C . PUT
- D . TRANSFER
Correct Answer: B
B
Explanation:
The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command. This command allows users to download data files that have been staged, making them available on the local file system for further use23.
B
Explanation:
The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command. This command allows users to download data files that have been staged, making them available on the local file system for further use23.
Question #153
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A . The warehouse size does not change until all queries currently running in the warehouse have completed.
- B . The warehouse size does not change until all queries currently in the warehouse queue have completed.
- C . The warehouse size does not change until the warehouse is suspended and restarted.
- D . It does not return from the command until the warehouse has finished changing its size.
Correct Answer: D
D
Explanation:
The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
D
Explanation:
The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #154
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data.
Based on this situation, what type of column does Snowflake recommend be used?
- A . ARRAY
- B . OBJECT
- C . TEXT
- D . VARIANT
Correct Answer: D
D
Explanation:
When dealing with semi-structured data in Snowflake, and the specific types of operations to be performed on the data are not yet determined, Snowflake recommends using the VARIANT data type. The VARIANT type is highly flexible and capable of storing data in multiple formats, including JSON, AVRO, BSON, and more, within a single column. This flexibility allows users to perform various operations on the data, including querying and manipulation of nested data structures without predefined schemas.
References:
Snowflake Documentation: Semi-structured Data Types
D
Explanation:
When dealing with semi-structured data in Snowflake, and the specific types of operations to be performed on the data are not yet determined, Snowflake recommends using the VARIANT data type. The VARIANT type is highly flexible and capable of storing data in multiple formats, including JSON, AVRO, BSON, and more, within a single column. This flexibility allows users to perform various operations on the data, including querying and manipulation of nested data structures without predefined schemas.
References:
Snowflake Documentation: Semi-structured Data Types
Question #155
What happens when a database is cloned?
- A . It does not retain any privileges granted on the source object.
- B . It replicates all granted privileges on the corresponding source objects.
- C . It replicates all granted privileges on the corresponding child objects.
- D . It replicates all granted privileges on the corresponding child schema objects.
Correct Answer: A
A
Explanation:
When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
A
Explanation:
When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question #156
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
- A . 1
- B . 5
- C . 10
- D . 100
Correct Answer: C
C
Explanation:
In Snowflake, the maximum number of clusters that can be provisioned within a multi-cluster virtual warehouse is 10. This allows for significant scalability and performance management by enabling Snowflake to handle varying levels of query load by adjusting the number of active clusters within the warehouse.
References: Snowflake documentation on virtual warehouses, particularly the scalability options available in multi-cluster configurations.
C
Explanation:
In Snowflake, the maximum number of clusters that can be provisioned within a multi-cluster virtual warehouse is 10. This allows for significant scalability and performance management by enabling Snowflake to handle varying levels of query load by adjusting the number of active clusters within the warehouse.
References: Snowflake documentation on virtual warehouses, particularly the scalability options available in multi-cluster configurations.
Question #157
What can a Snowflake user do in the Admin area of Snowsight?
- A . Analyze query performance.
- B . Write queries and execute them.
- C . Provide an overview of the listings in the Snowflake Marketplace.
- D . Connect to Snowflake partners to explore extended functionality.
Correct Answer: A
A
Explanation:
In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2.
A
Explanation:
In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2.
Question #158
Which Snowflake database object can be used to track data changes made to table data?
- A . Tag
- B . Task
- C . Stream
- D . Stored procedure
Correct Answer: C
C
Explanation:
A Stream object in Snowflake is used for change data capture (CDC), which records data manipulation
language (DML) changes made to tables, including inserts, updates, and deletes3.
C
Explanation:
A Stream object in Snowflake is used for change data capture (CDC), which records data manipulation
language (DML) changes made to tables, including inserts, updates, and deletes3.
Question #159
Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?
- A . COPY_INTO <location> command
- B . Data replication
- C . Snowpipe
- D . Direct share
Correct Answer: C
Question #160
A company’s security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.
Which of the following statements will return the required information?
- A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
- B . SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) - C . SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
- D . SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;
Correct Answer: D
D
Explanation:
To generate a report listing all Snowflake logins within the last 90 days, the ACCOUNT_USAGE.LOGIN_HISTORY view should be used. This view provides information about login attempts, including successful and unsuccessful logins, and is suitable for security audits4.
D
Explanation:
To generate a report listing all Snowflake logins within the last 90 days, the ACCOUNT_USAGE.LOGIN_HISTORY view should be used. This view provides information about login attempts, including successful and unsuccessful logins, and is suitable for security audits4.