Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.