Question 470
A database team repairs this problem: A nightly database maintenance script fails silently after its service account is disabled during an employee offboarding. Which measured outcome validates the correction?
Explanation
Correct Answer
The next maintenance run completes with auditable ownership and least-privilege access. This distinguishes actual recovery from a merely healthy-looking console. The targeted correction was: Move the scheduled job to an approved dedicated automation identity and monitor job outcomes.
Incorrect Answers
This finding relates to a situation in which a new database query takes seconds instead of milliseconds after a table passes several million rows. The current remediation must instead show that the next maintenance run completes with auditable ownership and least-privilege access.
That result would matter when an automatic backup schedule begins failing because a newly enforced organization policy denies its target storage location. It does not establish that the next maintenance run completes with auditable ownership and least-privilege access, which is the evidence needed here.
The result would be meaningful for a problem where a database patch window overlaps an annual financial close and the maintenance notice never reaches application owners. For this question, closure depends on confirming that the next maintenance run completes with auditable ownership and least-privilege access.