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

COF-C02 PDF — 1300 Questions

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

  1. Micro-partitions
  2. Clustering keys
  3. Key partitions
  4. Clustered partitions

Answer(s): B


Reference:

https://community.snowflake.com/s/article/Snowflake-What-the-Cluster



Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  1. Custom
  2. Economy
  3. Optimized
  4. Standard

Answer(s): B,D


Reference:

https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance



True or False: A single database can exist in more than one Snowflake account.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/ddl-database.html



Which of the following roles is recommended to be used to create and manage users and roles?

  1. SYSADMIN
  2. SECURITYADMIN
  3. PUBLIC
  4. ACCOUNTADMIN

Answer(s): B



True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  1. True
  2. False

Answer(s): A



Select the different types of Internal Stages: (Choose three.)

  1. Named Stage
  2. User Stage
  3. Table Stage
  4. Schema Stage

Answer(s): A,B,C


Reference:

https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage



True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.

  1. True
  2. False

Answer(s): B


Reference:

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



Account-level storage usage can be monitored via:

  1. The Snowflake Web Interface (UI) in the Databases section
  2. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
  3. The Information Schema -> ACCOUNT_USAGE_HISTORY View
  4. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-usage-billing.html



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