SnowPro Advanced: Architect — Question 63

What transformations are supported in the below SQL statement? (Choose three.)

CREATE PIPE ... AS COPY ... FROM (...)

Answer options

• A. Data can be filtered by an optional WHERE clause.
• B. Columns can be reordered.
• C. Columns can be omitted.
• D. Type casts are supported.
• E. Incoming data can be joined with other tables.
• F. The ON_ERROR - ABORT_STATEMENT command can be used.

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because the SQL statement allows for reordering of columns, omitting certain columns, and applying type casts. Options A, E, and F are not transformations that the COPY command supports, as filtering, joining with other tables, and using error commands are not part of the data transformation capabilities in this context.