SnowflakeSnowflake
COF-C02 · Question #198
COF-C02 Question #198: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #198. The question stem and answer options stay visible for context.
Data Loading and Unloading
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
Unlock COF-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Unloading#COPY INTO statement#Semi-structured data#File output options