SnowPro Core Certification — Question 157

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Answer options

• A. parse_json()
• B. json_extract_path_text()
• C. object_construct()
• D. flatten

Correct answer: A

Explanation

The correct answer is A, parse_json(), as it specifically converts a string formatted as JSON into a VARIANT type. The other options serve different purposes; json_extract_path_text() extracts specific values from JSON, object_construct() creates a JSON object, and flatten is used for normalizing nested data structures.