Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 700

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

Reorder the rows in a relational table and then unload the rows into a file.

Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

Reorder the data columns according to a target table definition and then unload the rows into the table.

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

The purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command is to convert the rows in a relational table to a single VARIANT column and then unload the rows into a file. This approach is useful for transforming tabular data into a semi-structured format such as JSON, which can then be easily managed and processed.

Discussion

ukpinoOption: B

Unloading a Relational Table to JSON¶ You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file.

MultiCloudIronManOption: B

Correct