Question 600
An Azure SQL operations team investigates: A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate.) is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected. It directly tests whether the remediation (Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.
Incorrect Answers
Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.
SQL server agent maintenance job schedules (4.1) addresses another technical failure: Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed. This case instead tests Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.
Azure powershell database automation (4.2) would demonstrate or implement: A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs. The paired-answer requirement concerns Troubleshooting job steps and retry behavior (4.1); this alternative does not provide the matching intervention and separate acceptance evidence.