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

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

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  1. Via the Snowflake Web Interface (UI)
  2. Via the DATA_SHARE=TRUE parameter
  3. Via SQL commands
  4. Via Virtual Warehouses

Answer(s): A,C


Reference:

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



True or False: Fail-safe can be disabled within a Snowflake account.

  1. True
  2. False

Answer(s): B



True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  1. True
  2. False

Answer(s): A



True or False: When Snowflake is configured to use Single Sign-On (SSO), Snowflake receives the usernames and credentials from the SSO service and loads them into the customer's Snowflake account.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-snowflake.html



Which of the following are best practices for loading data into Snowflake? (Choose three.)

  1. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
  2. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
  3. Enclose fields that contain delimiter characters in single or double quotes.
  4. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
  5. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
  6. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Answer(s): A,C,D






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

Join the COF-C02 Discussion