SnowPro Core Certification — Question 1041

Which transformation is supported by a COPY INTO [table] command?

Answer options

• 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

Correct answer: C

Explanation

The COPY INTO [table] command supports casting data through the use of a SELECT statement, which allows for transformation of data types. The other options, such as filtering with a WHERE clause or LIMIT keyword and ordering with an ORDER BY clause, are not supported by the COPY INTO command.