COF-C02 Exam Questions and Answers | Exam-Dumps (Page: 5)

QUESTION: 33

True or False: Snowpipe via REST API can only reference External Stages as source.

True
False

Answer(s): B

Reference:

https://community.snowflake.com/s/article/Making-Transient-table-by-Default

QUESTION: 34

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

True
False

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide-connecting.html

Reveal Solution Next Question

QUESTION: 35

True or False: It is possible to load data into Snowflake without creating a named File Format object.

True
False

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

Reveal Solution Next Question

QUESTION: 36

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True
False

Answer(s): B

Reveal Solution Next Question

QUESTION: 37

Which of the following statements are true of Snowflake data loading? (Choose three.)

VARIANT “null” values are not the same as SQL NULL values
It is recommended to do frequent, single row DMLs
It is recommended to validate the data before loading into the Snowflake target table
It is recommended to use staging tables to manage MERGE statements

Answer(s): A,C,D

Reveal Solution Next Question

QUESTION: 38

Which statements are true of micro-partitions? (Choose two.)

They are approximately 16MB in size
They are stored compressed only if COMPRESS=TRUE on Table
They are immutable
They are only encrypted in the Enterprise edition and above

Answer(s): A,C

Reference:

https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

Reveal Solution Next Question

QUESTION: 39

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True
False

Answer(s): B

Reveal Solution Next Question

QUESTION: 40

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed

Answer(s): B,D

Reveal Solution Next Question

Snowflake COF-C02 Exam (page: 5) Snowflake SnowPro Core Updated on: 12-Feb-2026

QUESTION: 33

Reference:

QUESTION: 34

Reference:

QUESTION: 35

Reference:

QUESTION: 36

QUESTION: 37

QUESTION: 38

Reference:

QUESTION: 39

QUESTION: 40

Snowflake COF-C02 Exam (page: 5)
Snowflake SnowPro Core
Updated on: 12-Feb-2026