What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)
What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)
In a CREATE PIPE ... AS COPY FROM statement, columns can indeed be reordered, allowing the data to be arranged in the desired column order upon loading. Additionally, columns can be omitted, meaning it is possible to load only specific columns from the incoming data into the target table. These transformations are supported to facilitate data preparation and ensure it aligns with the schema of the destination table. Other operations such as filtering data with a WHERE clause, joining with other tables, and defining row-level access are not supported in this context.
Was on exam Dec 31st 2022
CD is correct https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes
https://docs.snowflake.com/en/user-guide/data-load-transform.html
Using a query as the source for the COPY statement for column reordering [C], column omission [D], and casts (i.e. transforming data during a load) is supported. For usage examples, see Transforming Data During a Load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported [E].
as per documentation
Correct
https://docs.snowflake.com/en/user-guide/data-load-transform
C and D are correct
Correct Answer: CD
Correct Answer: CD
C and D are correct