Question 370
A database team reports a successful correction for this problem: A service receives intermittent out-of-memory query failures during complex sorting operations. What evidence supports closing the incident?
Explanation
Correct Answer
The workload completes without memory-kill events under peak concurrency. This is the intended effect of: Inspect query memory use and execution plans and tune operations or capacity safely. The original defect was concurrent memory-heavy sorts or hash operations exceed available execution memory.
Incorrect Answers
This finding belongs with a situation in which a globally used database has an RTO of fifteen minutes but its restore copies can only be downloaded over a constrained WAN link. The required acceptance finding here is that the workload completes without memory-kill events under peak concurrency.
This finding relates to a situation in which AlloyDB reports elevated CPU shortly after an index is added and application writes become slower. The current remediation must instead show that the workload completes without memory-kill events under peak concurrency.
This finding relates to a situation in which a production database throws quota errors after an ETL pipeline increases API requests by an order of magnitude. The current remediation must instead show that the workload completes without memory-kill events under peak concurrency.