SOL-C01 Question #186: Real Exam Question with Answer & Explanation

Question

You are using Snowpipe to load data into a table. You need to monitor the data loading process and identify any files that failed to load. Which of the following actions will provide you with information about the files that were processed by Snowpipe and their loading status, including error messages?

Options

• AQuery the 'VALIDATION MODE column in the target table to see if the data was successfully
• BUse the 'SYSTEM$PIPE STATUS function to check the status of the Snowpipe. If the status is
• CQuery the `COPY HISTORY' view in the `SNOWFLAKE database to view the history of COPY
• DEnable the ERROR copy option to log all errors to a separate table. Query this table to identify the
• EExamine the event logs generated by the cloud provider's event notification service (e.g., AWS

Explanation

The 'COPY HISTORY view in the 'SNOWFLAKES database provides detailed information about the COPY INTO statements executed by Snowpipe, including the files loaded, the number of rows loaded, and any error messages encountered during the loading process. This allows you to identify files that failed to load and understand the reasons for the failures. Option A is incorrect, 'VALIDATION_MODE' isn't a column. Option B provides general status, not file-specific details. Option D 'ON_ERROR can redirect bad records, but doesn't provide a history like COPY_HISTORY. option E relies on external logging, while `COPY_HISTORY is native to

No community discussion yet for this question.