Answer: STRIP_OUTER_ARRAY = TRUE

The question asks which file format command removes square brackets ([]) from JSON data when loading into Snowflake. According to the Snowflake documentation referenced in the community discussion, STRIP_OUTER_ARRAY = TRUE is specifically designed to remove outer brackets (i.e., [ ]) from JSON data. This is confirmed by the 100% community consensus on option D. The other options serve different purposes: STRIP_NULL_VALUES removes null values, REPLACE_INVALID_CHARACTERS handles invalid characters, and TRIM_SPACE removes whitespace, none of which address the removal of outer brackets.

Author: LeetQuiz Editorial Team