SnowPro Core Certification — Question 1236

What function should be used to convert JSON NULL values to SQL NULL values when loading data into a Snowflake table?

Answer options

• A. STRIP_OUTER_ARRAYS
• B. STRIP_NULL_VALUE
• C. FLATTEN
• D. PARSE_JSON

Correct answer: B

Explanation

The correct answer is B, STRIP_NULL_VALUE, as it specifically converts JSON NULL values to SQL NULL values during data loading. Options A, C, and D serve different purposes, such as manipulating arrays or parsing JSON, but do not address the conversion of NULL values.