Question 570
An Azure SQL operations team investigates: A DBA designs a recurring integrity check but never enables the SQL Agent schedule that should trigger it. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A DBA designs a recurring integrity check but never enables the SQL Agent schedule that should trigger it. The specific supported administrative response is: Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance. The technical risk is: Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed. Confirm the correction with: Job history records successful scheduled execution and its effect on the intended target database.
The acceptance evidence for this incident (A DBA designs a recurring integrity check but never enables the SQL Agent schedule that should trigger it.) is: Job history records successful scheduled execution and its effect on the intended target database. It directly tests whether the remediation (Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
SQL agent job alerts and operator notifications (4.1) addresses another technical failure: A job can fail repeatedly without incident response if its failure status is not routed to a responsible operator. The case states: A DBA designs a recurring integrity check but never enables the SQL Agent schedule that should trigger it. The most direct paired action and test is: Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
Azure cli SQL resource provisioning (4.2) addresses another technical failure: A command without correct scope can deploy resources to the wrong region or subscription despite succeeding. This choice can be useful for that problem, but it does not establish the SQL server agent maintenance job schedules (4.1) control being assessed here.
Fabric SQL database pipelines and recurring tasks (4.3) would demonstrate or implement: The Fabric pipeline or scheduled task runs against the intended database and its status is visible in the Fabric monitoring experience. The paired-answer requirement concerns SQL server agent maintenance job schedules (4.1); this alternative does not provide the matching intervention and separate acceptance evidence.