Snowflake
COF-R02 · Question #304
Which of the following can be used when unloading data from Snowflake? (Choose two.)
The correct answer is A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the. See the full explanation below for the reasoning.
Question
Which of the following can be used when unloading data from Snowflake? (Choose two.)
Options
- AWhen unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option
- 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
- DBy using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the
- EUse the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data
How the community answered
(24 responses)- A83% (20)
- B8% (2)
- C4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.