SnowPro Core Certification — Question 1116

Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows into a file in JSON format? (Choose two.)

Answer options

• A. PUT
• B. GET
• C. COPY
• D. EXPORT
• E. OBJECT_CONSTRUCT

Correct answer: C, E

Explanation

The correct answer is C and E because the COPY command is used to load data into Snowflake and can also unload data, while the OBJECT_CONSTRUCT function is utilized to create a VARIANT column from the rows. The PUT and GET commands are for file transfers, and EXPORT is not a valid command in Snowflake for this operation.