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

COF-C02 PDF — 1300 Questions

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  1. Scaling rhythmically
  2. Scaling max
  3. Scaling out
  4. Scaling up

Answer(s): C



Which statement best describes Snowflake tables?

  1. Snowflake tables are logical representations of underlying physical data
  2. Snowflake tables are the physical instantiation of data loaded into Snowflake
  3. Snowflake tables require that clustering keys be defined to perform optimally
  4. Snowflake tables are owned by a user

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html



Which item in the Data Warehouse migration process does not apply in Snowflake?

  1. Migrate Users
  2. Migrate Schemas
  3. Migrate Indexes
  4. Build the Data Pipeline

Answer(s): C



Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)

  1. Temporary Tables
  2. Transient Tables
  3. Provisional Tables
  4. Permanent Tables

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html



What is the maximum compressed row size in Snowflake?

  1. 8KB
  2. 16MB
  3. 50MB
  4. 4000GB

Answer(s): B



Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

  1. Databases
  2. Tables
  3. Warehouses
  4. Worksheets

Answer(s): A,C,D


Reference:

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



What is the recommended Snowflake data type to store semi-structured data like JSON?

  1. VARCHAR
  2. RAW
  3. LOB
  4. VARIANT

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html



Which of the following statements are true of Snowflake releases: (Choose two.)

  1. They happen approximately weekly
  2. They roll up and release approximately monthly, but customers can request early release application
  3. During a release, new customer requests/queries/connections transparently move over to the newer version
  4. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Answer(s): A,C



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