What tasks can be completed using the copy command? (Select TWO)

What tasks can be completed using the copy command? (Select TWO)
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

View Answer

Answer: C, D

Explanation:

The COPY command in Snowflake allows for the reordering of columns as they are loaded into a table, and it also permits the omission of columns from the source file during the load process. This provides flexibility in handling the schema of the data being ingested.

Reference: [COF-C02] SnowPro

Core Certification Exam Study Guide