Snowflake
COF-R02 · Question #115
COF-R02 Question #115: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #115. The question stem and answer options stay visible for context.
Question
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
Options
- AIt removes the last element of the outer array.
- BIt removes the outer array structure and loads the records into separate table rows,
- CIt removes the trailing spaces in the last element of the outer array and loads the records into
- DIt removes the NULL elements from the JSON object eliminating invalid data and enables the
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 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.