Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1066

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

Filter using a WHERE clause

Filter using a LIMIT keyword

Cast using a SELECT statement

Order using an ORDER BY Clause

Correct Answer: C

The COPY INTO [table] command supports transformations such as casting types using a SELECT statement. This allows for data type conversions during the load process, such as converting string data to dates or changing column data types.

Discussion

nexerSnowOption: C

The COPY command supports: Column reordering column omission casts using a SELECT statement https://docs.snowflake.com/en/user-guide/data-load-transform

cybe001Option: C

Correct Answer: C. Cast using a SELECT statement Explanation: Cast using a SELECT statement: When using the COPY INTO [table] command, you can include a SELECT statement that performs various transformations, including casting data types. This allows you to transform the data as it is loaded into the target table. For example, you can convert string data to a date format or change the data type of a column during the load process.