Which transformation is supported by a COPY INTO < table > command?
A.
Filter using a where clause
B.
Filter using a limit keyword
C.
Cast using a SELECT statement
D.
Order using an ORDER BY clause
The Answer Is:
C
This question includes an explanation.
Explanation:
The COPY INTO < table > command in Snowflake supports transformations such as casting using a SELECT statement. This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"