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

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

exams COF-C02 V2 COF-C02 exam 0 Comments

What transformations are supported in a CREATE PIPE … AS COPY … FROM (….)statement? (Select TWO.)
A . Data can be filtered by an optional where clause
B. Incoming data can be joined with other tables
C. Columns can be reordered
D. Columns can be omitted
E. Row level access can be defined

Answer: C,D