QUESTION: 21

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

True
False

Answer(s): A

Reference:

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

Reveal Solution Next Question

QUESTION: 22

Select the different types of Internal Stages: (Choose three.)

Named Stage
User Stage
Table Stage
Schema Stage

Answer(s): A,B,C

Reference:

https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

Reveal Solution Next Question

QUESTION: 23

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users
Warehouse size
Amount of data processed
# of clusters for the Warehouse

Answer(s): B,D

Explanation:

"Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."

Reference:

https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage

Reveal Solution Next Question

QUESTION: 24

True or False: The COPY command must specify a File Format in order to execute.

True
False

Answer(s): B

Explanation:

Create Stage:

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

Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html
Copy Into:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 7)

QUESTION: 21

Reference:

QUESTION: 22

Reference:

QUESTION: 23

Explanation:

Reference:

QUESTION: 24

Explanation:

COF-R02 Discussions & Posts