Question 440
A JSON ingestion sees one top-level array and wants its elements loaded individually with the file format. Which property should be evaluated?
Explanation
Correct Answer
Correct: STRIP_OUTER_ARRAY. STRIP_OUTER_ARRAY can unwrap an outer JSON array when loading documents.
Incorrect Answers
Incorrect for the stated load scenario: MATCH_BY_COLUMN_NAME maps supported input file columns to table columns by name; it does not provide STRIP_OUTER_ARRAY.
Incorrect for the stated load scenario: SELECT transformation in COPY applies supported expressions to staged fields during a COPY load; it does not provide STRIP_OUTER_ARRAY.
Incorrect for the stated load scenario: PARSE_JSON converts a valid JSON text string into a VARIANT value; it does not provide STRIP_OUTER_ARRAY.