What does the STRIP_OUTER_ARRAY file format do?

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?
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

View Answer

Answer: B

Explanation:

The STRIP_OUTER_ARRAY file format option in Snowflake is used when loading JSON documents that are composed of a large array containing multiple records. When this option is enabled, it removes the outer array structure, which allows each record within the array to be loaded as a separate row in the table. This is particularly useful for efficiently loading JSON data that is structured as an array of records1.

Reference: Snowflake Documentation on JSON File Format

[COF-C02] SnowPro Core Certification Exam Study Guide