Snowflake COF-C02 Exam - Topic 1 Question 78 Discussion

Question

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

Sharika · Accepted Answer

C) The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data. and D) By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Sharika · Answer

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

Sharika · Answer

B) Use the ENCODING file format option to change the encoding from the default UTF-8.

Sharika · Answer

E) Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.