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

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

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  1. Customers can change the size of the Warehouse after creation
  2. A Warehouse can be resized while running
  3. A Warehouse can be configured to suspend after a period of inactivity
  4. A Warehouse can be configured to auto-resume when new queries are submitted

Answer(s): A,B



The PUT command: (Choose two.)

  1. Automatically creates a File Format object
  2. Automatically uses the last Stage created
  3. Automatically compresses files using Gzip
  4. Automatically encrypts files

Answer(s): C,D


Reference:

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



Which type of table corresponds to a single Snowflake session?

  1. Temporary
  2. Transient
  3. Provisional
  4. Permanent

Answer(s): A



Which interfaces can be used to create and/or manage Virtual Warehouses?

  1. The Snowflake Web Interface (UI)
  2. SQL commands
  3. Data integration tools
  4. All of the above

Answer(s): D



When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  1. The Pipe load history is reset to empty
  2. The REFRESH parameter is set to TRUE
  3. Previously loaded files will be ignored
  4. All of the above

Answer(s): A






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

Join the COF-C02 Discussion