Answer: STRIP_OUTER_ARRAY

The STRIP_OUTER_ARRAY option is specifically designed to remove the outer array structure from JSON files during data loading in Snowflake. When a JSON file contains an outer array (e.g., [{"key": "value"}, {"key": "value"}]), using STRIP_OUTER_ARRAY in the COPY INTO command or file format definition strips this outer array, allowing each object within the array to be loaded as a separate row in the table. This is confirmed by the community discussion where all responses (100%) select option C, with one comment linking to Snowflake documentation on semi-structured data considerations that supports this functionality. Option A (SKIP_BYTE_ORDER_MARK) handles byte order marks in files, not JSON structure. Option B (STRIP_NULL_VALUE) removes null values from data, which is unrelated to array stripping. Option D (STRIP_OUTER_ELEMENT) is not a valid Snowflake file format option.

Author: LeetQuiz Editorial Team