Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 602

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

The default value for the SINGLE option is set to TRUE.

By default, COPY INTO statements do not separate table data into a set of output files.

The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.

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

The correct description of how to unload data from a Snowflake table involves the use of the OBJECT_CONSTRUCT function combined with the COPY command to convert rows in a relational table into a single VARIANT column. This allows for the rows to be unloaded into a file while maintaining their structure.

Discussion

OTEOption: C

"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." https://docs.snowflake.com/en/user-guide/data-unload-considerations

ShagunMittalOption: C

Option D will also be correct if Decompressed is written instead of compressed at the end of statement.

subhataanu

had option D said 'can be uncompressed', then it'll be true. i.e specify compression method/extension for 'decompression'

MultiCloudIronManOption: C

Correct