SnowPro Core Certification — Question 1112

Which function is used to unload a relational table into a JSON file?

Answer options

• A. PARSE_JSON
• B. JSON_EXTRACT_PATH_TEXT
• C. OBJECT_CONSTRUCT
• D. TO_JSON

Correct answer: D

Explanation

The correct answer is D, TO_JSON, which is specifically designed to convert relational data into JSON format. The other options serve different purposes; PARSE_JSON is used for parsing JSON strings, JSON_EXTRACT_PATH_TEXT retrieves values from a JSON object, and OBJECT_CONSTRUCT creates a JSON object from key-value pairs, but none are used for unloading a table into JSON.