SnowPro Core Certification — Question 997

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

Answer options

• A. PARSE_JSON
• B. CHECK_JSON
• C. JSON_EXTRACT_PATH_TEXT
• D. PARSE_XML

Correct answer: A

Explanation

The correct answer is PARSE_JSON, which is specifically designed to parse an input string as a JSON document and return a VARIANT value. CHECK_JSON is used to validate JSON format but does not produce a VARIANT. JSON_EXTRACT_PATH_TEXT extracts text from a JSON object, and PARSE_XML is for processing XML data, not JSON.