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

View Answer

Answer: A, D

Explanation:

In a CREATE PIPE … AS COPY … FROM (….) statement, the supported transformations include

filtering data using an optional WHERE clause and omitting columns. The WHERE clause allows for the specification of conditions to filter the data that is being loaded, ensuring only relevant data is inserted into the table. Omitting columns enables the exclusion of certain columns from the data load, which can be useful when the incoming data contains more columns than are needed for the target table.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Simple Transformations During a Load1