Which file format option should be set to STRIP_NULL_VALUES=TRUE when loading JSON files to remove null values representing missing data?

• A. STRIP_NULL_VALUES=FALSE
• B. STRIP_NULL_VALUES=TRUE
• C. NULL_IF
• D. TRIM_SPACE

Answer: (B)

Stripping null-valued fields during JSON load is controlled by the STRIP_NULL_VALUES setting. Setting STRIP_NULL_VALUES to TRUE removes any fields whose values are null, so they don’t appear in the loaded data. This is exactly how you remove missing data representations from the dataset. If you leave it FALSE, those null fields are preserved as nulls in the loaded data. The other options don’t address removing nulls: NULL_IF maps certain strings to NULL during load, and TRIM_SPACE removes leading or trailing spaces in string values. Therefore, STRIP_NULL_VALUES=TRUE is the correct choice to remove null values.