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.)

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