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

Question

Richard Banks · Accepted Answer

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Richard Banks · Accepted Answer

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Richard Banks · Answer

Use the ENCODING file format option to change the encoding from the default UTF-8.

Richard Banks · Answer

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

Richard Banks · Answer

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

List of questions