Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-C02

Snowflake COF-C02 Exam Questions
SnowPro Core (Page 15 )

Updated On: 17-Feb-2026
Page 15 of 221
PDF with 1300 Questions

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






Post your Comments and Discuss Snowflake COF-C02 exam dumps with other Community members:

Join the COF-C02 Discussion