What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).

The correct answer is B. Reordering the columns D. Converting the datatypes. The COPY INTO command supports a SELECT sub-clause that allows lightweight transformations during load. Specifically, you can (B) reorder columns by changing the order of positional references (e.g., $2, $1, $3) and (D) convert datatypes using cast functions (e.g…

Data Loading and Unloading

Question

Options

APerforming aggregate calculations
BReordering the columns
CGrouping by operations
DConverting the datatypes
ESelecting the first few rows

How the community answered

(34 responses)

A
6% (2)
B
91% (31)
C
3% (1)

Explanation

The COPY INTO command supports a SELECT sub-clause that allows lightweight transformations during load. Specifically, you can (B) reorder columns by changing the order of positional references (e.g., $2, $1, $3) and (D) convert datatypes using cast functions (e.g., $2::INTEGER). Aggregate calculations (A) and GROUP BY operations (C) are not supported - COPY INTO is not a query engine. Selecting only the first few rows (E) via LIMIT is also unsupported in the COPY INTO context.

Topics

#COPY INTO command#Data loading transformations#Column reordering#Data type conversion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice