Question 580
An Azure SQL operations team investigates: An operations review needs evidence that an alert is both generated and acknowledged when a scheduled task fails. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (An operations review needs evidence that an alert is both generated and acknowledged when a scheduled task fails.) is: A controlled failed job sends the expected notification and records the error in job history. It directly tests whether the remediation (Configure supported SQL Server Agent alerts, operators and notification mechanisms for important job failures or database conditions.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: An operations review needs evidence that an alert is both generated and acknowledged when a scheduled task fails. The specific supported administrative response is: Configure supported SQL Server Agent alerts, operators and notification mechanisms for important job failures or database conditions. The technical risk is: A job can fail repeatedly without incident response if its failure status is not routed to a responsible operator. Confirm the correction with: A controlled failed job sends the expected notification and records the error in job history.
Incorrect Answers
Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This case instead tests SQL agent job alerts and operator notifications (4.1); the choice measures or changes another part of the system.
Azure SQL resource deployment using bicep (4.2) addresses another technical failure: Manual production configuration can drift from tested resource sizing, networking and backup settings. The required paired action and test concerns SQL agent job alerts and operator notifications (4.1); a passing result for this alternative could leave that requirement unresolved.
Azure cli SQL resource provisioning (4.2) would demonstrate or implement: CLI output and an independent resource readback confirm the database was created with intended settings. The paired-answer requirement concerns SQL agent job alerts and operator notifications (4.1); this alternative does not provide the matching intervention and separate acceptance evidence.