DEA-C02 Data Movement Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  STRIP_NULL_VALUES = TRUE

  Why it's wrong here

  STRIP_NULL_VALUES removes object fields whose value is null when loading JSON, which reduces stored data but does not change how arrays are decomposed into rows. Files with a top-level array would still load as a single row containing the array unless the outer array is stripped, so this option does not address the requirement.

• ✗

  REPLACE_INVALID_CHARACTERS = TRUE

  Why it's wrong here

  REPLACE_INVALID_CHARACTERS replaces invalid UTF-8 sequences with a replacement character, helping with encoding issues in text data. It does not alter the structure of JSON arrays, so each object would not become its own row. This option addresses data cleanliness, not row formation from an array.

• ✓

  STRIP_OUTER_ARRAY = TRUE

  Why this is correct

  STRIP_OUTER_ARRAY removes the outer brackets of a top-level JSON array so that each element is treated as a separate row during loading. This is exactly the behavior needed when files contain an array of objects and each object should map to a row. It is a property of the JSON file format used by COPY INTO.

• ✗

  SKIP_HEADER = 1

  Why it's wrong here

  SKIP_HEADER applies to delimited files such as CSV, where it skips a specified number of header lines. It is not a JSON file format option and has no effect on array decomposition. Applying it to JSON would not produce one row per object and would leave the top-level array intact.