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
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.
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.
The Answer Is:
B
This question includes an explanation.
Explanation:
The OBJECT_CONSTRUCT function is used with the COPY INTO command 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
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"