Answer-first summary for fast verification
Answer: Columns can be reordered., Columns can be omitted.
The question asks for two tasks that can be accomplished using the COPY command. Based on Snowflake documentation and the community discussion (with 100% consensus on CD and upvoted comments referencing official docs), the COPY command supports column reordering (C) and column omission (D) through its transformation capabilities. However, it does not support aggregation (A) or JOIN operations (B), as explicitly stated in the documentation link shared in the discussion. While data loading without a virtual warehouse (E) is possible for some operations like Snowpipe, the COPY command itself typically requires a virtual warehouse for execution, making E incorrect for this specific command context.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two tasks can be accomplished using the COPY command?
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.
No comments yet.