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 #191
Which Snowflake feature can be used to find sensitive data in a table or column?
- A . Masking policies
- B . Data classification
- C . Row level policies
- D . External functions
Correct Answer: B
B
Explanation:
Data classification in Snowflake is a feature that allows organizations to identify and categorize data stored in tables or columns based on its sensitivity level or content type. This feature can be used to find sensitive data within the database by classifying data as confidential, personal, public, etc., making it easier to apply appropriate security measures, such as masking policies or row-level security, to protect sensitive information.
References:
Snowflake Documentation: Data Classification
B
Explanation:
Data classification in Snowflake is a feature that allows organizations to identify and categorize data stored in tables or columns based on its sensitivity level or content type. This feature can be used to find sensitive data within the database by classifying data as confidential, personal, public, etc., making it easier to apply appropriate security measures, such as masking policies or row-level security, to protect sensitive information.
References:
Snowflake Documentation: Data Classification
Question #192
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
- A . Query execution
- B . Data loading
- C . Time Travel data
- D . Security
- E . Authentication and access control
Correct Answer: D, E
D, E
Explanation:
The cloud services layer of Snowflake architecture handles various aspects including security functions, authentication of user sessions, and access control, ensuring that only authorized users can access the data and services23.
D, E
Explanation:
The cloud services layer of Snowflake architecture handles various aspects including security functions, authentication of user sessions, and access control, ensuring that only authorized users can access the data and services23.
Question #193
Which statement describes Snowflake tables?
- A . Snowflake tables arc logical representation of underlying physical data.
- B . Snowflake tables are the physical instantiation of data loaded into Snowflake.
- C . Snowflake tables require that clustering keys be defined lo perform optimally.
- D . Snowflake tables are owned by a use.
Correct Answer: A
A
Explanation:
In Snowflake, tables represent a logical structure through which users interact with the stored data. The actual physical data is stored in micro-partitions managed by Snowflake, and the logical table structure provides the means by which SQL operations are mapped to this data. This architecture allows Snowflake to optimize storage and querying across its distributed, cloud-based data storage system.
References: Snowflake Documentation on Tables
A
Explanation:
In Snowflake, tables represent a logical structure through which users interact with the stored data. The actual physical data is stored in micro-partitions managed by Snowflake, and the logical table structure provides the means by which SQL operations are mapped to this data. This architecture allows Snowflake to optimize storage and querying across its distributed, cloud-based data storage system.
References: Snowflake Documentation on Tables
Question #194
What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?
- A . Use Snowflake’s native API.
- B . Use a custom-built connector.
- C . Contact Snowflake Support for a new driver.
- D . Connect through Snowflake’s JDBC or ODBC drivers
Correct Answer: D
D
Explanation:
If a user needs to connect to Snowflake with a tool or technology that is not listed in Snowflake’s partner ecosystem, Snowflake recommends using its JDBC or ODBC drivers. These drivers provide a standard method of connecting from various tools and programming languages to Snowflake, offering wide compatibility and flexibility. By using these drivers, users can establish connections to Snowflake from their applications, ensuring they can leverage the capabilities of Snowflake regardless of the specific tools or technologies they are using.
References: Snowflake Documentation on Client Drivers
D
Explanation:
If a user needs to connect to Snowflake with a tool or technology that is not listed in Snowflake’s partner ecosystem, Snowflake recommends using its JDBC or ODBC drivers. These drivers provide a standard method of connecting from various tools and programming languages to Snowflake, offering wide compatibility and flexibility. By using these drivers, users can establish connections to Snowflake from their applications, ensuring they can leverage the capabilities of Snowflake regardless of the specific tools or technologies they are using.
References: Snowflake Documentation on Client Drivers
Question #195
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production.
How can data be easily transferred from the production account to the non-production account?
- A . Clone the data from the production account to the non-production account.
- B . Create a data share from the production account to the non-production account.
- C . Create a subscription in the production account and have it publish to the non-production account.
- D . Create a reader account using the production account and link the reader account to the non-production account.
Correct Answer: B
B
Explanation:
To easily transfer data from a production account to a non-production account in Snowflake within the same cloud provider region, creating a data share is the most efficient approach. Data sharing allows for live, read-only access to selected data objects from the production account to the non-production account without the need to duplicate or move the actual data. This method facilitates seamless access to the data for development, testing, or analytics purposes in the non-production environment.
References: Snowflake Documentation: Data Sharing
B
Explanation:
To easily transfer data from a production account to a non-production account in Snowflake within the same cloud provider region, creating a data share is the most efficient approach. Data sharing allows for live, read-only access to selected data objects from the production account to the non-production account without the need to duplicate or move the actual data. This method facilitates seamless access to the data for development, testing, or analytics purposes in the non-production environment.
References: Snowflake Documentation: Data Sharing
Question #196
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A . ROLES
- B . POLICY_REFERENCES
- C . QUERY_HISTORY
- D . RESOURCE_MONIT ORS
- E . ACCESS_HISTORY
Correct Answer: B, E
B, E
Explanation:
To evaluate the details of dynamic data masking, the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used.
The POLICY_REFERENCES view provides information about the objects to which a masking policy is applied, and the ACCESS_HISTORY view contains details about access to the masked data, which can be used to audit and verify the application of dynamic data masking policies.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Dynamic Data Masking1
B, E
Explanation:
To evaluate the details of dynamic data masking, the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used.
The POLICY_REFERENCES view provides information about the objects to which a masking policy is applied, and the ACCESS_HISTORY view contains details about access to the masked data, which can be used to audit and verify the application of dynamic data masking policies.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Dynamic Data Masking1
Question #197
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A . Compute layer
- B . Storage layer
- C . Cloud infrastructure layer
- D . Cloud services layer
Correct Answer: D
D
Explanation:
Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects of the Snowflake service, including authentication, infrastructure management, metadata management, query parsing and optimization, and security. By handling these tasks, the Cloud Services layer enables the Compute layer to focus on executing queries, while the Storage layer is dedicated to persistently storing data.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowflake Architecture1
D
Explanation:
Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects of the Snowflake service, including authentication, infrastructure management, metadata management, query parsing and optimization, and security. By handling these tasks, the Cloud Services layer enables the Compute layer to focus on executing queries, while the Storage layer is dedicated to persistently storing data.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowflake Architecture1
Question #198
What is the default File Format used in the COPY command if one is not specified?
- A . CSV
- B . JSON
- C . Parquet
- D . XML
Correct Answer: A
A
Explanation:
The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for data exchange because it is simple, easy to read, and supported by many data analysis tools.
A
Explanation:
The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for data exchange because it is simple, easy to read, and supported by many data analysis tools.
Question #199
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
- A . Access control
- B . Fail-safe
- C . Network policies
- D . Time Travel
Correct Answer: D
D
Explanation:
Snowflake’s Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.
D
Explanation:
Snowflake’s Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.
Question #200
When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?
- A . SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
- B . SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
- C . SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
- D . SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);
Correct Answer: C
C
Explanation:
In Snowflake, SAMPLE (5 ROWS) ensures an exact count of 5 rows is returned from MY_TABLE, regardless of table size. This is different from SAMPLE SYSTEM or SAMPLE BERNOULLI, which use percentage-based sampling, potentially returning varying row counts based on probabilistic methods.
The ROWS option is deterministic and does not depend on percentage, making it ideal when an exact row count is required.
C
Explanation:
In Snowflake, SAMPLE (5 ROWS) ensures an exact count of 5 rows is returned from MY_TABLE, regardless of table size. This is different from SAMPLE SYSTEM or SAMPLE BERNOULLI, which use percentage-based sampling, potentially returning varying row counts based on probabilistic methods.
The ROWS option is deterministic and does not depend on percentage, making it ideal when an exact row count is required.