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

Question

You are using Snowsight to monitor a data pipeline that involves several tasks chained together using 'AFTER' dependencies. One of the intermediate tasks, is failing intermittently. Which of the following Snowsight features would be MOST helpful in quickly identifying the root cause of the failures and assessing the impact on downstream tasks?

Options

• AThe Snowsight worksheet interface, by running SELECT statements on the underlying data in the
• BThe task history view in Snowsight, focusing on the execution details, error messages, and query
• CThe data lineage feature in Snowsight to visualize the data flow and dependencies between the
• DThe Resource Monitor page to see if warehouses are being over utilized and impacting all
• EThe role hierarchy page to see if the role executing the task has the correct privileges.

Explanation

The task history view in Snowsight provides specific information about the execution of each task, including error messages, query profiles, and execution times. This allows you to pinpoint the cause of the failure in and examine the history of predecessor tasks to identify any upstream issues. The Task details page shows which tasks were executed after the specific task. While data lineage (Option C) is helpful for understanding data flow, it doesn't directly show execution details. Option A (worksheets) is a general debugging tool but not the most efficient for task- specific issues. Options D and E might be relevant but are less direct than examining the task

No community discussion yet for this question.