Question 380
A database team wants to prevent a recurrence of this issue: A database operations team cannot trace a permissions incident because its audit events are retained for only one day. Which preventive practice is most relevant?
Explanation
Correct Answer
Test log retrieval across the full investigation window before changing retention. It targets the actual operating weakness: Logging retention is shorter than the incident investigation and compliance window. The immediate repair was: Set appropriate supported audit log retention and restricted evidence access.
Incorrect Answers
The proposed check would review execution plans for high-volume filters after data growth, helping with cases where a new database query takes seconds instead of milliseconds after a table passes several million rows. The recurring exposure described here is that logging retention is shorter than the incident investigation and compliance window.
This safeguard helps protect cases where Cloud SQL request latency spikes during lunchtime although average CPU remains normal. It leaves the main recurring failure untouched: logging retention is shorter than the incident investigation and compliance window.
This would validate database identity changes when enterprise account names or groups change. It is useful when database administrators receive repeated authentication failures after SSO identities are renamed, but it does not prevent the issue here: logging retention is shorter than the incident investigation and compliance window.