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

COF-C02 PDF — 1300 Questions

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  1. Number of users
  2. Warehouse size
  3. Amount of data processed
  4. # of clusters for the Warehouse

Answer(s): B,D



Which statement best describes `clustering`?

  1. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
  2. The database administrator must define the clustering methodology for each Snowflake table
  3. The clustering key must be included on the COPY command when loading data into Snowflake
  4. Clustering can be disabled within a Snowflake account

Answer(s): A


Reference:

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



True or False: The COPY command must specify a File Format in order to execute.

  1. True
  2. False

Answer(s): B



Which of the following commands sets the Virtual Warehouse for a session?

  1. COPY WAREHOUSE FROM <<config file>>;
  2. SET WAREHOUSE = <<warehouse name>>;
  3. USE WAREHOUSE <<warehouse name>>;
  4. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer(s): C


Reference:

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



Which of the following objects can be cloned? (Choose four.)

  1. Tables
  2. Named File Formats
  3. Schemas
  4. Shares
  5. Databases
  6. Users

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



Which object allows you to limit the number of credits consumed within a Snowflake account?

  1. Account Usage Tracking
  2. Resource Monitor
  3. Warehouse Limit Parameter
  4. Credit Consumption Tracker

Answer(s): B


Reference:

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



Snowflake is designed for which type of workloads? (Choose two.)

  1. OLAP (Analytics) workloads
  2. OLTP (Transactional) workloads
  3. Concurrent workloads
  4. On-premise workloads

Answer(s): A,C



What are the three layers that make up Snowflake's architecture? (Choose three.)

  1. Compute
  2. Tri-Secret Secure
  3. Storage
  4. Cloud Services

Answer(s): A,C,D


Reference:

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html



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