Question 400
A compliance pipeline must reject a COPY job when a malformed row appears rather than loading partially. Which option is appropriate?
Explanation
Correct Answer
Correct: abort the statement on detected errors. ON_ERROR = ABORT_STATEMENT stops a bulk load when an input parsing or conversion error is encountered.
Incorrect Answers
Incorrect for the stated load scenario: ON_ERROR = CONTINUE attempts to load valid rows while reporting rows that caused errors; it does not provide abort the statement on detected errors.
Incorrect for the stated load scenario: ON_ERROR = SKIP_FILE skips an entire input file when it has qualifying errors; it does not provide abort the statement on detected errors.
Incorrect for the stated load scenario: VALIDATION_MODE = RETURN_ERRORS returns detected load errors without committing an ordinary data load; it does not provide abort the statement on detected errors.