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

COF-C02 PDF — 1300 Questions

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  1. To accommodate more queries
  2. To accommodate more users
  3. To accommodate fluctuations in workload
  4. To accommodate a more complex workload

Answer(s): D



True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

  1. True
  2. False

Answer(s): B


Reference:

https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/



Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

  1. JDBC
  2. SnowSQL
  3. Snowflake Web Interface (UI)
  4. ODBC
  5. Python

Answer(s): A,B,C,D,E


Reference:

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



True or False: Snowflake charges a premium for storing semi-structured data.

  1. True
  2. False

Answer(s): B


Reference:

https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflake-charges-premium-for-storing-semi-structured-data



Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

  1. Growth of storage and compute are tightly coupled together
  2. Storage expands without the requirement to add more compute
  3. Compute can be scaled up or down without the requirement to add more storage
  4. Multiple compute clusters can access stored data without contention

Answer(s): B,C,D



True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

  1. True
  2. False

Answer(s): A


Reference:

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



In which layer of its architecture does Snowflake store its metadata statistics?

  1. Storage Layer
  2. Compute Layer
  3. Database Layer
  4. Cloud Services Layer

Answer(s): D


Reference:

https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/



True or False: Data in fail-safe can be deleted by a user or the Snowflake team before it expires.

  1. True
  2. False

Answer(s): B


Reference:

https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/



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