SnowPro Advanced: Data Engineer — Question 98

How can a Data Engineer return all the errors encountered during a previous file upload that used the COPY command?

Answer options

• A. Query the VALIDATE information schema view.
• B. Call the VALIDATE table function.
• C. Call the VALIDATE_PIPE_LOAD table function.
• D. Query the VALIDATE account usage schema view.

Correct answer: B

Explanation

The correct answer is B because the VALIDATE table function specifically returns errors from a previous COPY command execution. Option A and D refer to schema views that do not provide detailed error information, while option C pertains to a different function related to pipe loads, not the COPY command.