Which ON_ERROR option is NOT valid when loading data with COPY INTO?

• A. ON_ERROR = CONTINUE
• B. ON_ERROR = ABORT_STATEMENT
• C. ON_ERROR = SKIP_FILE_<num>
• D. ON_ERROR = ROLLBACK

Answer: (D)

On_ERROR controls how Snowflake responds to errors during a COPY INTO load. The valid settings specify how to proceed after a failure: CONTINUE keeps processing and skips problematic data, ABORT_STATEMENT stops the load for that statement, and SKIP_FILE_ skips a certain number of failed files. ROLLBACK isn’t part of these options because ON_ERROR is about data-load error handling, not transaction control. To revert changes, you’d issue a separate ROLLBACK TRANSACTION, not set ON_ERROR to ROLLBACK.