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

Question

Your team has set up an automated data pipeline to load data into Snowflake using the *COPY INTO' command from an S3 bucket. After some time, you notice that some files in the bucket are not being loaded, and you suspect this is due to errors during the loading process. You want to implement a monitoring solution to track these failed file loads and take appropriate action. What are the BEST ways to achieve this? Choose all that apply

Options

• AExamine the 'VALIDATE function output after each *COPY INTO' operation to check for any
• BQuery the 'COPY_HISTORY view in the 'SNOWFLAKE database to review the load status and
• CParse the output of the 'COPY INTO' command to capture the number of rows successfully loaded
• DImplement an external monitoring tool to scan the S3 bucket for files that have not been modified
• EUtilize Snowflake's error notification system to receive alerts when a 'COPY INTO' command

Explanation

Option B: The 'COPY_HISTORY view in the 'SNOWFLAKE database provides a comprehensive overview of all 'COPY INTO operations, including their status, the number of rows loaded, and any error messages encountered during the loading process. This view is an excellent resource for monitoring and troubleshooting data loading issues. Option C: Parsing the output of the 'COPY INTO' command allows you to capture the number of rows successfully loaded and any error messages. This information can be used to identify failed loads and take appropriate action. 'VALIDATE function (option A) is used for debugging copy commands but is not appropriate for ongoing monitoring. Option D is a possible, but ineffecient, solution. Snowflake does not have a direct error notification system built in for 'COPY INTO' command errors (option E).

No community discussion yet for this question.