
Answer-first summary for fast verification
Answer: STRIP_NULL_VALUE
The STRIP_NULL_VALUE function is specifically designed to convert JSON null values to SQL NULL values while leaving other variant values unchanged. This is explicitly stated in Snowflake's documentation and confirmed by the community discussion where option D received 86% of the votes and multiple comments with upvotes reference the official documentation. While TO_VARIANT (option B) was considered by some users, the community consensus and detailed reasoning in the comments indicate that STRIP_NULL_VALUE is the more precise and correct answer for this specific conversion task. Options A (TO_CHAR) and C (TO_VARCHAR) are string conversion functions and not relevant for converting JSON null to SQL NULL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.