Snowflake

COF-R02 · Question #142

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

The correct answer is C. Columns can be reordered D. Columns can be omitted. See the full explanation below for the reasoning.

Question

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Options

AData can be filtered by an optional where clause
BIncoming data can be joined with other tables
CColumns can be reordered
DColumns can be omitted
ERow level access can be defined

How the community answered

(45 responses)

A
9% (4)
B
16% (7)
C
73% (33)
E
2% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full COF-R02 Practice