SnowPro Core Certification — Question 379

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?

Answer options

• 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.

Correct answer: B

Explanation

The STRIP_OUTER_ARRAY file format option removes the outer array structure, allowing each record to be loaded as a separate row in the table, which is essential for proper data organization within Snowflake. The other options are incorrect because they either misinterpret the functionality or describe actions that do not occur with this specific file format option.