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

The correct answer is C. Columns can be reordered D. Columns can be omitted. The Snowflake COPY INTO command supports column-level transformations during loading via a SELECT subquery inside the COPY statement. This enables: (C) reordering columns - you can specify columns in any order different from the source file; and (D) omitting columns - you can…

Data Loading and Unloading

Question

Options

AColumns can be aggregated
BColumns can be joined with an existing table
CColumns can be reordered
DColumns can be omitted
EData can be loaded without the need to spin up a virtual warehouse

How the community answered

(26 responses)

C
96% (25)
E
4% (1)

Explanation

The Snowflake COPY INTO command supports column-level transformations during loading via a SELECT subquery inside the COPY statement. This enables: (C) reordering columns - you can specify columns in any order different from the source file; and (D) omitting columns - you can selectively load only certain columns from the staged file, leaving others at their default values. Option A (aggregating columns) is not supported; COPY does not perform GROUP BY or aggregate functions. Option B (joining with an existing table) is not possible within a COPY command. Option E is incorrect because COPY INTO requires an active, running virtual warehouse to process data - it is not a serverless operation.

Topics

#COPY INTO command#Data loading#Column selection#Data transformation basics

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice