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

The correct answer is C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the. The OBJECT_CONSTRUCT function is used in Snowflake to create a JSON object from relational data, which is useful when unloading semi-structured data. The SINGLE = TRUE parameter is used when unloading data to ensure that the data is exported as a single file, which can be up to…

Data Loading and Unloading

Question

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

(25 responses)

B
4% (1)
C
88% (22)
E
8% (2)

Explanation

The OBJECT_CONSTRUCT function is used in Snowflake to create a JSON object from relational data, which is useful when unloading semi-structured data. The SINGLE = TRUE parameter is used when unloading data to ensure that the data is exported as a single file, which can be up to 5 GB in size.

Topics

#Data Unloading#COPY INTO statement#Semi-structured data#File output options

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice