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

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

How does Snowflake Fail-safe protect data in a permanent table?

  1. Fail-safe makes data available up to 1 day, recoverable by user operations.
  2. Fail-safe makes data available for 7 days, recoverable by user operations.
  3. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  4. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Answer(s): C



A virtual warehouse is created using the following command:

Create warehouse my_WH with -
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.


What action should be taken to address this situation?

  1. Increase the warehouse size from Medium to 2XL.
  2. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  3. Configure the warehouse to a multi-cluster warehouse.
  4. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer(s): C



Which minimum Snowflake edition allows for a dedicated metadata store?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake

Answer(s): D


Reference:

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



Network policies can be set at which Snowflake levels? (Choose two.)

  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables

Answer(s): C,E


Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies



What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  1. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 30 days.
    Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 365 days.
    Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days.
    Maximum Time Travel Retention is 1 day.
    Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days.
    Maximum Time Travel Retention is 7 days.
    Fail Safe retention time is 356 days.

Answer(s): D






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

Join the COF-C02 Discussion