Snowflake Exam COF-R02 Topic 1 Question 16 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 16
Topic #: 1

Which of the following can be used when unloading data from Snowflake? (Choose two.)

AWhen unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

BUse the ENCODING file format option to change the encoding from the default UTF-8.

CThe OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

DBy using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

EUse the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Show Suggested Answer

Suggested Answer: A, D

by Renea at Jul 26, 2023, 11:11 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!