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

Question

A data engineer needs to schedule a Snowflake task to refresh a materialized view named 'mv customer summary' every hour. They want to ensure that Snowsight is used to monitor the task's execution history and performance. Which of the following actions is the MOST efficient way to achieve this, focusing on Snowsight features?

Options

• ACreate a Snowsight dashboard with a table displaying all task executions and manually check it
• BUse the Snowsight task monitoring page to view the task history, execution status, and error logs
• CConfigure Snowsight alerts based on task execution status (e.g., 'Failed', 'Aborted') to receive
• DDevelop a custom application that queries the Snowflake system functions like
• EUse the classic web UI because Snowsight lacks the necessary monitoring capabilities for tasks.

Explanation

Snowsight provides a dedicated task monitoring page and allows configuration of alerts based on task execution status. This is the most efficient way to monitor task execution and receive notifications when issues occur. Options A, D and E are less efficient or unnecessary given I Snowsight's built-in capabilities. Option B is partly correct, but the most proactive approach is to leverage alerts.

No community discussion yet for this question.