Answer: Cast using a SELECT statement

The correct answer is C because the COPY INTO command in Snowflake supports transformations through a SELECT statement, which can include casting data types, column reordering, and column omission during the load process. This is explicitly documented in Snowflake's user guide and confirmed by the community discussion with upvoted comments. Options A (WHERE clause), B (LIMIT keyword), and D (ORDER BY clause) are not supported transformations in the COPY INTO command, as they are filtering, limiting, or ordering operations that cannot be performed directly within the COPY INTO statement.

Author: LeetQuiz Editorial Team