Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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._