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

COF-C02 PDF — 1300 Questions

How a Snowpipe charges calculated?

  1. Per-second/per Warehouse size
  2. Per-second/per-core granularity
  3. Number of Pipes in account
  4. Total storage bucket size

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html



True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

  1. True
  2. False

Answer(s): B



True or False: When active, a Pipe requires a dedicated Virtual Warehouse to execute.

  1. True
  2. False

Answer(s): B



True or False: Snowflake supports federated authentication in all editions.

  1. True
  2. False

Answer(s): A


Reference:

https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions-MC6N3I63LJGNGMHCTKGKFDH4NH2Q



True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

  1. True
  2. False

Answer(s): B



True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  1. True
  2. False

Answer(s): B


Reference:

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



True or False: During data unloading, only JSON and CSV files can be compressed.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html



Which of the following are options when creating a Virtual Warehouse? (Choose two.)

  1. Auto-suspend
  2. Auto-resume
  3. Local SSD size
  4. User count

Answer(s): A,B


Reference:

https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse



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