snowpro-core question 934 discussion

View all snowpro core here
back to snowflake forum

Question 934

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.
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0 / 1000
vr15305
6 months, 3 weeks ago

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