CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps

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


Reference:

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



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

Explanation:

"When a pipe is recreated, the load history is dropped."
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history



What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  1. Standard
  2. Premier
  3. Enterprise
  4. Business Critical Edition

Answer(s): D


Reference:

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






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

COF-R02 Discussions & Posts