SnowPro Core Certification — Question 1117

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO [table] command when loading data from a JSON file into a table?

Answer options

• A. It flattens multiple arrays into a single array.
• B. It removes the outer array structure and loads separate rows of data.
• C. It transforms a pivoted table into an array.
• D. It tokenizes each data string using the defined delimiters.

Correct answer: B

Explanation

The correct answer, B, is accurate because the STRIP_OUTER_ARRAY parameter effectively removes the outer array structure, allowing each element to be loaded as a separate row. The other options describe different functionalities that do not pertain to the purpose of STRIP_OUTER_ARRAY, such as flattening arrays or tokenizing strings.