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

Updated On: 16-Feb-2026
Page 13 of 221
PDF with 1300 Questions

Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

  1. SnowSQL
  2. ODBC
  3. R
  4. HIVE

Answer(s): A,B


Reference:

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



Which of the following DML commands isn't supported by Snowflake?

  1. UPSERT
  2. MERGE
  3. UPDATE
  4. TRUNCATE TABLE

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/sql-dml.html



Which of the following statements is true of zero-copy cloning?

  1. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
  2. All zero-copy clone objects inherit the privileges of their original objects
  3. Zero-copy cloning is licensed as an additional Snowflake feature
  4. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Answer(s): D


Reference:

https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data



True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  1. True
  2. False

Answer(s): B



The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  1. 60 minutes
  2. 24 hours
  3. 14 days
  4. 30 days
  5. 1 year

Answer(s): C






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

Join the COF-C02 Discussion