Answer-first summary for fast verification
Answer: Columns can be reordered., Columns can be omitted.
The question asks about transformations supported in a CREATE PIPE ... AS COPY INTO ... FROM statement, requiring selection of two correct options. Based on Snowflake documentation and the community discussion consensus (100% agreement on CD with multiple upvoted comments), options C and D are correct. C is correct because columns can be reordered using a SELECT query in the COPY statement. D is correct because columns can be omitted by not including them in the SELECT query. Option A is incorrect because filtering with a WHERE clause is not supported in this context. Option B is incorrect because joining with other tables is not allowed in the simple SELECT statements used in pipes. Option E is incorrect because row-level access control is not a transformation feature of the COPY statement in pipes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which transformations are supported in a CREATE PIPE ... AS COPY INTO ... FROM statement? (Choose 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.