SnowPro Core Certification — Question 444

What tasks can be completed using the COPY command? (Choose two.)

Answer options

• A. Columns can be aggregated.
• B. Columns can be joined with an existing table.
• C. Columns can be reordered.
• D. Columns can be omitted.
• E. Data can be loaded without the need to spin up a virtual warehouse.

Correct answer: C, D

Explanation

The COPY command allows for the reordering and omission of columns when importing data, hence options C and D are correct. Options A and B involve operations that are not supported by the COPY command, while option E relates to data loading capabilities but does not pertain to column manipulation.