SnowPro Core Certification — Question 690

What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

Answer options

• A. Reorder the rows in a relational table and then unload the rows into a file.
• B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.
• C. Reorder the data columns according to a target table definition and then unload the rows into the table.
• D. Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.

Correct answer: B

Explanation

The correct answer is B because the OBJECT_CONSTRUCT function is used to convert multiple columns of a relational table into a single VARIANT column for export. The other options either describe incorrect processes or do not specifically involve the conversion of relational table rows into a VARIANT format.