SnowPro Core Certification — Question 552

Which COPY INTO statement accurately describes how to unload data from a Snowflake table?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer, C, is accurate because it highlights how the OBJECT_CONSTRUCT function can be utilized with the COPY command to change multiple rows into a single VARIANT column. Options A and B are misleading as they do not pertain directly to unloading data from a table. Option D incorrectly implies that file naming is tied to the COMPRESSION option, which is not the primary function of the COPY INTO statement.