SnowPro Core Certification — Question 1000

Which Snowflake function will parse a JSON-null into a SQL-null?

Answer options

• A. TO_CHAR
• B. TO_VARIANT
• C. TO_VARCHAR
• D. STRIP_NULL_VALUE

Correct answer: D

Explanation

The correct answer is D, as the STRIP_NULL_VALUE function specifically handles the conversion of JSON-null to SQL-null. Options A, B, and C do not perform this specific operation, as they are used for different data type conversions and do not address null handling in the context of JSON.