SnowPro Core Certification — Question 577

While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

Answer options

• A. SKIP_BYTE_ORDER_MARK
• B. STRIP_NULL_VALUE
• C. STRIP_OUTER_ARRAY
• D. STRIP_OUTER_ELEMENT

Correct answer: C

Explanation

The correct answer, STRIP_OUTER_ARRAY, specifically functions to remove the outer array layer from a JSON structure, facilitating the loading of each record into distinct table rows. The other options do not serve this purpose; for example, SKIP_BYTE_ORDER_MARK deals with byte order marks, and STRIP_NULL_VALUE pertains to handling null entries.