SnowPro Core Certification — Question 405

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

Answer options

• A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
• B. Use the ENCODING file format option to change the encoding from the default UTF-8.
• C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
• D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Correct answer: C, D

Explanation

The correct answers are C and D because the OBJECT_CONSTRUCT function indeed converts relational data to semi-structured data, and the SINGLE = TRUE parameter allows exporting a single file up to 5 GB. Options A, B, and E are incorrect as they either pertain to recommendations not directly related to the unloading process or involve file encoding changes that are not central to the unloading capabilities.