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 #201
Which transformation techniques are supported for bulk loading data into Snowflake using the copy into <table> command? (Select TWO)
- A . Column grouping
- B . Column omission
- C . Column reordering
- D . Column aggregation
- E . Selection of a limited number of rows
Correct Answer: B, C
Question #202
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
- A . Bytes scanned
- B . Partitions scanned
- C . Bytes spilled to local storage
- D . Bytes spilled to remote storage
- E . Percentage scanned from cache
Correct Answer: C, D
C, D
Explanation:
The Query Profile statistics that indicate intermediate results do not fit in memory are the bytes spilled to local storage and bytes spilled to remote storage2.
C, D
Explanation:
The Query Profile statistics that indicate intermediate results do not fit in memory are the bytes spilled to local storage and bytes spilled to remote storage2.
Question #203
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
- A . VIEWS_HISTORY
- B . OBJECT_HISTORY
- C . ACCESS_HISTORY
- D . LOGIN_HISTORY
Correct Answer: C
C
Explanation:
The ACCESS_HISTORY view in the SNOWFLAKE.ACCOUNT_USAGE schema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.
C
Explanation:
The ACCESS_HISTORY view in the SNOWFLAKE.ACCOUNT_USAGE schema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.
Question #204
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
- A . DATA_RETENTION_TIME_IN_DAYS
- B . MAX_DATA_EXTENSION_TIME_IN_DAYS
- C . MIN_DATA_RETENTION_TIME_IN_DAYS
- D . MAX CONCURRENCY LEVEL
Correct Answer: A
A
Explanation:
The parameter DATA_RETENTION_TIME_IN_DAYS can be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.
A
Explanation:
The parameter DATA_RETENTION_TIME_IN_DAYS can be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.
Question #205
How can a user get the MOST detailed information about individual table storage details in Snowflake?
- A . SHOW TABLES command
- B . SHOW EXTERNAL TABLES command
- C . TABLES view
- D . TABLE STORAGE METRICS view
Correct Answer: D
D
Explanation:
To get the most detailed information about individual table storage details in Snowflake, the TABLE STORAGE METRICS view should be used. This Information Schema view provides granular storage metrics for tables within Snowflake, including data related to the size of the table, the amount of data stored, and storage usage over time. It’s an essential tool for administrators and users looking to monitor and optimize storage consumption and costs.
References:
Snowflake Documentation: Information Schema – TABLE STORAGE METRICS View
D
Explanation:
To get the most detailed information about individual table storage details in Snowflake, the TABLE STORAGE METRICS view should be used. This Information Schema view provides granular storage metrics for tables within Snowflake, including data related to the size of the table, the amount of data stored, and storage usage over time. It’s an essential tool for administrators and users looking to monitor and optimize storage consumption and costs.
References:
Snowflake Documentation: Information Schema – TABLE STORAGE METRICS View
Question #206
What are characteristic of Snowsight worksheet? (Select TWO.)
- A . Worksheets can be grouped under folder, and a folder of folders.
- B . Each worksheet is a unique Snowflake session.
- C . Users are limited to running only one on a worksheet.
- D . The Snowflake session ends when a user switches worksheets.
- E . Users can import worksheets and share them with other users.
Correct Answer: A, E
A, E
Explanation:
Characteristics of Snowsight worksheets in Snowflake include:
A, E
Explanation:
Characteristics of Snowsight worksheets in Snowflake include:
Question #207
Which activities are managed by Slowflake’s Cloud Services layer? (Select TWO).
- A . Authorisation
- B . Access delegation
- C . Data pruning
- D . Data compression
- E . Query parsing and optimization
Correct Answer: A, E
A, E
Explanation:
Snowflake’s Cloud Services layer is responsible for managing various aspects of the platform that are not directly related to computing or storage. Specifically, it handles authorisation, ensuring that users have appropriate access rights to perform actions or access data. Additionally, it takes care of query parsing and optimization, interpreting SQL queries and optimizing their execution plans for better performance. This layer abstracts much of the platform’s complexity, allowing users to focus on their data and queries without managing the underlying infrastructure.
References: Snowflake Architecture Documentation
A, E
Explanation:
Snowflake’s Cloud Services layer is responsible for managing various aspects of the platform that are not directly related to computing or storage. Specifically, it handles authorisation, ensuring that users have appropriate access rights to perform actions or access data. Additionally, it takes care of query parsing and optimization, interpreting SQL queries and optimizing their execution plans for better performance. This layer abstracts much of the platform’s complexity, allowing users to focus on their data and queries without managing the underlying infrastructure.
References: Snowflake Architecture Documentation
Question #208
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
- A . NUMBER
- B . OBJECT
- C . STRING
- D . VARCHAR
- E . VARIANT
Correct Answer: B, E
B, E
Explanation:
Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation. OBJECT can directly contain VARIANT, and thus indirectly contain any other data type,
including itself1.
B, E
Explanation:
Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation. OBJECT can directly contain VARIANT, and thus indirectly contain any other data type,
including itself1.
Question #209
Which items are considered schema objects in Snowflake? (Select TWO).
- A . Pipe
- B . File format
- C . Resource monitor
- D . Storage integration
- E . Virtual warehouse
Correct Answer: A, B
A, B
Explanation:
In Snowflake, schema objects include Pipes and File formats. Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake
A, B
Explanation:
In Snowflake, schema objects include Pipes and File formats. Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake
Question #210
What does SnowCD help Snowflake users to do?
- A . Copy data into files.
- B . Manage different databases and schemas.
- C . Troubleshoot network connections to Snowflake.
- D . Write SELECT queries to retrieve data from external tables.
Correct Answer: C
C
Explanation:
SnowCD is a connectivity diagnostic tool that helps users troubleshoot network connections to Snowflake. It performs a series of checks to evaluate the network connection and provides suggestions for resolving any issues4.
C
Explanation:
SnowCD is a connectivity diagnostic tool that helps users troubleshoot network connections to Snowflake. It performs a series of checks to evaluate the network connection and provides suggestions for resolving any issues4.