SnowPro Core Certification — Question 523

What Snowflake function should be used to unload relational data to JSON?

Answer options

• A. BUILD_STAGE_FILE_URL()
• B. OBJECT_CONSTRUCT()
• C. PARSE_JSON()
• D. TO_VARIANT()

Correct answer: B

Explanation

The correct answer is B, OBJECT_CONSTRUCT(), as it creates a JSON object from relational data, allowing for effective unloading to JSON format. Options A, C, and D serve different purposes: A is for generating file URLs, C is to parse JSON strings into objects, and D converts values to the VARIANT data type.