Question 2

Explanation

✅ ABORT_STATEMENT

Explanation:

By default, the COPY INTO command in Snowflake uses ON_ERROR = ABORT_STATEMENT. This means that if any error occurs during the data load—such as a data type mismatch or missing column—the entire statement is aborted immediately. This conservative approach ensures data integrity by preventing partial or inconsistent loads unless explicitly overridden.

❌ Why the other options are incorrect?

• CONTINUE → Incorrect, because this option must be explicitly set. It tells Snowflake to skip problematic rows and continue loading the rest, but it is not the default.

• SKIP_FILE → Incorrect, as this skips the entire file if an error is encountered, but again, it must be manually specified.

• VALIDATE → Incorrect, since VALIDATION_MODE is a separate parameter used to check data quality without actually loading it. It’s not an error-handling mode for COPY INTO.

For more details, refer to Snowflake’s COPY INTO documentation.