QUESTION: 165

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

ORC
XML
Avro
Parquet
JSON

Answer(s): D,E

Explanation:

Semi-structured JSON, Parquet

Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)

Reveal Solution Next Question

QUESTION: 166

What is the purpose of an External Function?

To call code that executes outside of Snowflake
To run a function in another Snowflake database
To share data in Snowflake with external parties
To ingest data from on-premises data sources

Answer(s): A

Reference:

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

Reveal Solution Next Question

QUESTION: 167

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

Create a zero-copy clone of the worksheet and grant permissions to teammates
Create a private Data Exchange so that any teammate can use the worksheet
Share the worksheet with teammates within Snowsight
Create a database and grant all permissions to teammates

Answer(s): C

Reveal Solution Next Question

QUESTION: 168

What is the purpose of multi-cluster virtual warehouses?

To create separate data warehouses to increase query optimization
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
To eliminate or reduce Queuing of concurrent queries
To allow the warehouse to resize automatically

Answer(s): C

Reference:

https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 43)

QUESTION: 165

Explanation:

Reference:

QUESTION: 166

Reference:

QUESTION: 167

QUESTION: 168

Reference:

COF-R02 Discussions & Posts