Answer: strip_outer_array = true

The correct answer is C because when loading JSON files larger than 16 MB into Snowflake, the 'strip_outer_array = true' option removes the outer array structure, allowing the individual JSON objects within the array to be loaded as separate table rows. This bypasses the 16 MB row size limitation since each individual JSON object (rather than the entire array) becomes a row. Option A (trim_space) is irrelevant for JSON size limitations as it handles whitespace in string values. Option B (compression = auto) deals with file compression but doesn't address the row size limitation. Option D (strip_outer_array = false) would maintain the outer array structure, causing the entire file to be treated as a single row, which would exceed the 16 MB limit for large files.

Author: LeetQuiz Editorial Team