Answer-first summary for fast verification
Answer: Load the records into separate table rows.
The STRIP_OUTER_ARRAY file format option, when used with COPY INTO command, serves two main purposes: it removes the outer array structure from JSON/parquet files AND loads each element of that array as separate table rows. This is explicitly stated in Snowflake documentation and confirmed by the community discussion where all responses (100%) select option A, with upvoted comments providing detailed reasoning and references to official documentation. Option B is incorrect as unloading is not related to this format option. Option C is unrelated to STRIP_OUTER_ARRAY functionality. Option D describes data type consistency but is not the primary effect of STRIP_OUTER_ARRAY.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO <table> command to remove the outer array structure from the data files.
What is the additional effect of using this file format option in conjunction with the COPY INTO command?
A
Load the records into separate table rows.
B
Unload the records from separate table rows.
C
Export data files in smaller chunks.
D
Ensure each unique element stores values of a single native data type.