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

COF-C02 PDF — 1300 Questions

Fail-safe is unavailable on which table types? (Choose two.)

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

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Which of the following objects is not covered by Time Travel?

  1. Tables
  2. Schemas
  3. Databases
  4. Stages

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/data-time-travel.html



True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  1. True
  2. False

Answer(s): A


Reference:

https://blog.ippon.tech/innovative-snowflake-features-caching/



Which of the following commands are not blocking operations? (Choose two.)

  1. UPDATE
  2. INSERT
  3. MERGE
  4. COPY

Answer(s): B,D



Which of the following is true of Snowpipe via REST API? (Choose two.)

  1. You can only use it on Internal Stages
  2. All COPY INTO options are available during pipe creation
  3. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
  4. Snowpipe keeps track of which files it has loaded

Answer(s): C,D



Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

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

Answer(s): D


Reference:

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



When can a Virtual Warehouse start running queries?

  1. 12am-5am
  2. Only during administrator defined time slots
  3. When its provisioning is complete
  4. After replication

Answer(s): C



True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html



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