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

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

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  1. UPDATE TABLE FROM STREAM
  2. SELECT FROM STREAM
  3. INSERT INTO TABLE SELECT FROM STREAM
  4. ALTER TABLE AS SELECT FROM STREAM
  5. BEGIN COMMIT

Answer(s): A,C



Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  1. Use the DROP command after the load completes.
  2. Specify the TEMPORARY option when creating the file format.
  3. Specify the PURGE copy option in the COPY INTO command.
  4. Use the REMOVE command after the load completes.
  5. Use the DELETE LOAD HISTORY command after the load completes.

Answer(s): C,D



On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

  1. Amazon Web Services
  2. Private Virtual Cloud
  3. Oracle Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Alibaba Cloud

Answer(s): A,D,E



What Snowflake role must be granted for a user to create and manage accounts?

  1. ACCOUNTADMIN
  2. ORGADMIN
  3. SECURITYADMIN
  4. SYSADMIN

Answer(s): B



Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?





Answer(s): A






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

Join the COF-C02 Discussion