Answer-first summary for fast verification
Answer: The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.
Option C is correct because the Snowflake documentation explicitly states that OBJECT_CONSTRUCT function can be combined with the COPY command to convert relational table rows to a single VARIANT column for unloading. The community discussion confirms this with 100% consensus and references to official documentation. Option A is incorrect because the SINGLE option defaults to FALSE, not TRUE. Option B is incorrect because COPY INTO statements do separate data into multiple files by default. Option D is incorrect because while you can specify compression methods, the statement wording is flawed - specifying file extensions doesn't enable compression; rather, it helps with decompression when loading compressed files.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which COPY INTO statement is true about how to unload data from a Snowflake table?
A
The default value for the SINGLE option is set to TRUE.
B
By default, COPY INTO [location] statements do not separate table data into a set of output files.
C
The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.
D
If the COMPRESSION option is set to TRUE, a file's name can be specified with the appropriate file extension so that the output file can be compressed.
