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-C01 V1 COF-C01 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