Question 420
A migration team validates 1,000 load rows for format errors before the first live import. Which mode fits?
Explanation
Correct Answer
Correct: COPY validation. COPY VALIDATION_MODE inspects potential COPY errors without loading rows.
Incorrect Answers
Incorrect for the stated load scenario: LIST @stage shows staged files and supported file metadata; it does not provide COPY validation.
Incorrect for the stated load scenario: SELECT FROM @stage previews staged data using an applicable file format; it does not provide COPY validation.
Incorrect for the stated load scenario: VALIDATE table function reports parsing errors from a prior supported COPY load operation; it does not provide COPY validation.