SnowPro Core Certification — Question 795

Which function should be used to insert JSON formatted string data into a VARIANT field?

Answer options

• A. FLATTEN
• B. CHECK_JSON
• C. PARSE_JSON
• D. TO_VARIANT

Correct answer: C

Explanation

The correct answer is PARSE_JSON, as this function is specifically designed to convert JSON formatted strings into VARIANT data types. The other options do not perform this specific task; FLATTEN is used for flattening semi-structured data, CHECK_JSON validates JSON strings without conversion, and TO_VARIANT converts other data types to VARIANT but does not specifically handle JSON strings.