SnowPro Core Certification — Question 1268

When creating a file format to load JSON data into Snowflake, what command will remove brackets ([]) from the data?

Answer options

• A. STRIP_NULL_VALUES = TRUE
• B. REPLACE_INVALID_CHARACTERS = TRUE
• C. TRIM_SPACE = TRUE
• D. STRIP_OUTER_ARRAY = TRUE

Correct answer: D

Explanation

The command STRIP_OUTER_ARRAY = TRUE is specifically designed to remove outer brackets from JSON data, making it the correct choice. The other options pertain to different functions: STRIP_NULL_VALUES handles nulls, REPLACE_INVALID_CHARACTERS addresses character issues, and TRIM_SPACE removes leading and trailing spaces, but none of these affect the array brackets.