Answer: PARSE_JSON

The PARSE_JSON function is the correct choice because it explicitly converts JSON data (including JSON null values) into Snowflake's VARIANT data type, during which JSON null values are automatically converted to SQL NULL values. This is the standard approach for handling JSON data in Snowflake. While STRIP_NULL_VALUE can remove null values from JSON objects, it does not perform the initial conversion from JSON to SQL data types and is typically used after parsing. The community discussion shows a split between options B and D, but the more detailed and technically accurate explanation supports PARSE_JSON as the primary function for this conversion during data loading.

Author: LeetQuiz Editorial Team