SnowPro Core Certification — Question 380

What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)

Answer options

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

Correct answer: C, D

Explanation

The correct answers are C and D because the CREATE PIPE statement allows for reordering and omitting columns during data ingestion. Options A, B, and E are incorrect as filtering, joining with other tables, and defining row-level access are not supported transformations in this context.