Question 19
Domain 5: Monitoring and AlertingYou want a notification after every failed task attempt in a job that uses retries. What should you configure?
Correct answer: D
Explanation
Task-level failure notifications are tied to each task attempt, so they fire after every failed retry. This matches the need for a notification "after every failed task attempt" in a job that uses retries.
Why each option is right or wrong
A. Only job-level success notifications
Job-level success alerts trigger on overall completion, not on each failed retry attempt.
B. Only SQL warehouse query tags
Query tags label or categorize workloads; they do not send failure notifications.
C. Only a duration warning threshold
Duration warnings monitor runtime length, not whether each retry attempt failed.
D. Task-level failure notifications
The requirement is tied to each individual execution attempt, not the overall job outcome, so the notification must be configured at the task scope. In retrying jobs, a task can fail multiple times before the job is ultimately marked failed, and task-level failure notifications are the mechanism that triggers on each failed attempt rather than waiting for final exhaustion of retries.