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

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

What are supported file formats for unloading data from Snowflake? (Choose three.)

  1. XML
  2. JSON
  3. Parquet
  4. ORC
  5. AVRO
  6. CSV

Answer(s): B,C,F


Reference:

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



The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

  1. Local disk caching
  2. Authentication and access control
  3. Metadata management
  4. Query processing
  5. Database storage

Answer(s): B,C



What is a key feature of Snowflake architecture?

  1. Zero-copy cloning creates a mirror copy of a database that updates with the original.
  2. Software updates are automatically applied on a quarterly basis.
  3. Snowflake eliminates resource contention with its virtual warehouse implementation.
  4. Multi-cluster warehouses allow users to run a query that spans across multiple clusters.
  5. Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date.

Answer(s): C



When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  1. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  2. The listing is replicated into all selected regions automatically, the data is not.
  3. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
  4. Shares attached to listings in remote regions can be viewed from any account in an organization.
  5. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer(s): B,E



When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  1. 10-50 MB
  2. 100-250 MB
  3. 300-500 MB
  4. 1000-1500 MB

Answer(s): B






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

Join the COF-C02 Discussion