Which COPY INTO statement accurately describes 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 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.
"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
had option D said 'can be uncompressed', then it'll be true. i.e specify compression method/extension for 'decompression'
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
OTE
Highly Voted 1 year, 8 months agoMultiCloudIronMan
Most Recent 1 year, 7 months agoShagunMittal
1 year, 8 months agoaemilka
1 month, 1 week agosubhataanu
5 months, 2 weeks ago