nerdexam
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)
  • A
    83% (20)
  • B
    8% (2)
  • C
    4% (1)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice