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

COF-C02 PDF — 1300 Questions

Which of the following are common use cases for zero-copy cloning? (Choose three.)

  1. Quick provisioning of Dev and Test/QA environments
  2. Data backups
  3. Point in time snapshots
  4. Performance optimization

Answer(s): A,B,C


Reference:

https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning



If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  1. 4
  2. 16
  3. 32
  4. 128

Answer(s): A


Reference:

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



True or False: When a data share is established between a Data Provider and a Data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html



Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  1. Is available to all Snowflake Editions
  2. Is only available to customers with Business Critical Edition
  3. Restricts or enables access to specific IP addresses
  4. Is activated using an “ALTER DATABASE” command

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html



True or False: Snowflake charges additional fees to Data Providers for each Share they create.

  1. True
  2. False

Answer(s): B



Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

  1. 1 Hour
  2. 3 Hours
  3. 12 hours
  4. 24 hours

Answer(s): D


Reference:

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse



A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  1. The tables are now orphaned
  2. The user that deleted the role
  3. SYSADMIN
  4. The assumed role that dropped the role

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/drop-role.html



Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

  1. SnowSQL
  2. ODBC
  3. R
  4. HIVE

Answer(s): A,B


Reference:

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



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