Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Snowflake
  3. COF-C02

Snowflake SnowPro Core COF-C02 Exam Questions in PDF

Free Snowflake COF-C02 Dumps Questions (page: 5)

COF-C02 PDF — 1300 Questions

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

  1. True
  2. False

Answer(s): B


Reference:

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



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.

  1. True
  2. False

Answer(s): A


Reference:

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



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

  1. True
  2. False

Answer(s): A


Reference:

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



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

  1. True
  2. False

Answer(s): B



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

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

Answer(s): A,C,D



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

  1. They are approximately 16MB in size
  2. They are stored compressed only if COMPRESS=TRUE on Table
  3. They are immutable
  4. 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



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.

  1. True
  2. False

Answer(s): B



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

  1. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
  2. 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
  3. 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
  4. The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed

Answer(s): B,D



Viewing page 5 of 139

Share your comments for Snowflake COF-C02 exam with other users:

A
AI Tutor Explanation
4/25/2026 1:42:20 PM

Question 104:

  • Correct answer: D) Multi-Terabyte (TB) Range

  • Brief explanation:
- clustering keys organize data into micro-partitions to improve pruning when queries filter on those columns. - The performance benefit is most significant for very large tables; for small tables the overhead of maintaining clustering outweighs gains. - Therefore, as a best practice, define clustering keys on tables at the TB scale.

Thane, India
A
AI Tutor Explanation
4/21/2026 8:48:36 AM

Question 3:

  • False is the correct answer (Option B).

Why:
  • In Snowflake, a database is a metadata object that exists within a single Snowflake account. Accounts are isolated—there isn’t one database that lives in multiple accounts.
  • You can access data across accounts via data sharing or database replication, but these create separate database objects in the other accounts (e.g., a database in the consumer account created from a share), not a single shared database across accounts.

So a single database cannot exist in more than one Snowflake account.

Thane, India
AI Tutor 👋 I’m here to help!