SnowPro Core Certification — Question 961
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
Answer options
- A. RETURN_-1_ROWS
- B. RETURN_n_ROWS
- C. RETURN_ERRORS
- D. RETURN_ALL_ERRORS
Correct answer: D
Explanation
The correct answer is D, RETURN_ALL_ERRORS, as it ensures comprehensive error reporting for all files, including those with partial loads. The other options either do not capture all errors or are not relevant for the specific requirement of tracking all errors across multiple loads.