Answer-first summary for fast verification
Answer: The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data., By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
The question asks for two correct options when unloading data from Snowflake. Option C is correct because OBJECT_CONSTRUCT can convert relational data to semi-structured JSON format during unloading, as documented in Snowflake's unloading considerations. Option D is correct because the SINGLE = TRUE parameter allows exporting data to a single file up to 5 GB in size, which is explicitly mentioned in Snowflake's documentation. Option A is incorrect because STRIP_OUTER_ARRAY is used when loading semi-structured data, not unloading. Option B is incorrect because Snowflake only supports UTF-8 encoding for unloading; the ENCODING option cannot change this. Option E is incorrect because PARSE_JSON is used for parsing JSON strings into VARIANT during data loading or querying, not for ensuring data type during unloading. The community discussion strongly supports CD with 86% consensus and references to official documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following options can be used to unload data from Snowflake? (Choose two.)
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.
No comments yet.