Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
