- All Exams Instant Download
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
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
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
1 Comment
5 days ago
- wrong answer, the correct are C D, reviewed the question in examtopics and snowflake docu CREATE PIPE | Snowflake Documentation … “Using a query as the source for the COPY statement for column reordering, column omission, 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.”
