Question 140
Security needs SQL audit data for an extended period but storage cleanup deletes logs after a week. The team is considering this step: Configure a governed audit sink and retention/alerting policies with access separation. What evidence should they review before proceeding?
Explanation
Correct Answer
Check retention obligations, storage lifecycle rules and immutable storage support. Audit retention must align with legal, threat-detection and tamper-resistance requirements. Audit events remain queryable for the required duration after simulated cleanup.
Incorrect Answers
A present SQL audit count cannot prove records survive the required years. Review retention obligations and actual storage lifecycle rules.
An audit sink that can be silently deleted may fail tamper-resistance obligations. Inspect immutable retention and access separation.
Fast ingestion does not establish long-term audit access. Verify queries against events older than the current cleanup interval and monitor expiry policy.