SnowPro Core Certification — Question 937

Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?

Answer options

• A. FLATTEN
• B. OBJECT_AS
• C. OBJECT_CONSTRUCT
• D. TO_VARIANT

Correct answer: C

Explanation

The correct answer is C. OBJECT_CONSTRUCT is specifically designed to convert relational table rows into a VARIANT column while enabling export to JSON format. The other options, such as FLATTEN and TO_VARIANT, do not serve this combined purpose, and OBJECT_AS is not applicable for this scenario.