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: 13)

COF-C02 PDF — 1300 Questions

What is the lowest Snowflake edition that offers Time Travel up to 90 days?

  1. Standard Edition
  2. Premier Edition
  3. Enterprise Edition
  4. Business Critical Edition

Answer(s): C


Reference:

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



Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  1. A Schema may contain one or more Databases
  2. A Database may contain one or more Schemas
  3. A Schema is a logical grouping of Database Objects
  4. Each Schema is contained within a Warehouse

Answer(s): B,C


Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html



True or False: You can resize a Virtual Warehouse while queries are running.

  1. True
  2. False

Answer(s): A


Reference:

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



What is the most granular object that the Time Travel retention period can be defined on?

  1. Account
  2. Database
  3. Schema
  4. Table

Answer(s): D



Which of the following statements is true of Snowflake micro-partitioning?

  1. Micro-partitioning has been known to introduce data skew
  2. Micro-partitioning: requires a partitioning schema to be defined up front
  3. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
  4. Micro-partitioning can be disabled within a Snowflake account

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html



True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  1. True
  2. False

Answer(s): B


Reference:

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



When scaling up Virtual Warehouses by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

  1. Concurrency
  2. Performance

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance



As a best practice, clustering keys should only be defined on tables of which minimum size?

  1. Multi-Kilobyte (KB) Range
  2. Multi-Megabyte (MB) Range
  3. Multi-Gigabyte (GB) Range
  4. Multi-Terabyte (TB) Range

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html



Viewing page 13 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!