Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A user is loading JSON documents that consist of a large outer array containing multiple records into Snowflake. The user enables the STRIP_OUTER_ARRAY file format option.
What is the function of the STRIP_OUTER_ARRAY file format option?
A
It removes the last element of the outer array.
B
It removes the outer array structure and loads the records into separate table rows.
C
It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns.
D
It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records.
