QUESTION: 105

Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO
GET
WRITE
EXTRACT INTO

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%2 0your%20stage.

Reveal Solution Next Question

QUESTION: 106

How often are encryption keys automatically rotated by Snowflake?

30 Days
60 Days
90 Days
365 Days

Answer(s): A

Explanation:

All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.

Reference:

https://docs.snowflake.com/en/user-guide/security-encryption- manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automati cally%20destroyed.

Reveal Solution Next Question

QUESTION: 107

What are value types that a VARIANT column can store? (Select TWO)

STRUCT
OBJECT
BINARY
ARRAY
CLOB

Answer(s): B,D

Explanation:

Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

Reference:

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

Reveal Solution Next Question

QUESTION: 108

A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes
Create a task that puts the files in an internal stage and automate the data loading wizard
Create a task that runs a GET operation to intermittently check for new files
Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Answer(s): D

Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 28)

QUESTION: 105

Reference:

QUESTION: 106

Explanation:

Reference:

QUESTION: 107

Explanation:

Reference:

QUESTION: 108

Reference:

COF-R02 Discussions & Posts