SnowPro Core Certification — Question 371

Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)

Answer options

• A. TRUE
• B. RETURN_ERROR_SUM
• C. RETURN_ALL_ERRORS
• D. RETURN_[N]_ROWS
• E. RETURN_FIRST__ERRORS

Correct answer: C, D

Explanation

The correct answers, C (RETURN_ALL_ERRORS) and D (RETURN_[N]_ROWS), are valid options that determine how validation errors are handled during the COPY_INTO operation. Options A, B, and E are not valid for the VALIDATION_MODE parameter in this context.