ExamGecko
Question list
Search
Search

Question 265 - SnowPro Core discussion

Report
Export

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

A.
Reorder the rows in a relational table and then unload the rows into a file
Answers
A.
Reorder the rows in a relational table and then unload the rows into a file
B.
Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.
Answers
B.
Convert the rows in a relational table lo 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.
Answers
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.
Answers
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.
Suggested answer: B

Explanation:

TheOBJECT_CONSTRUCTfunction is used with theCOPY INTOcommand to convert the rows in a relational table to a single VARIANT column, which can then be unloaded into a file.This is useful for transforming table data into a semi-structured JSON format

asked 23/09/2024
Kevin Margan
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first