Question 700
Following the issue — An Azure SQL Managed Instance writes audit records to an inaccessible storage destination and nobody notices missing logs. — the team takes this action: Correct audit destination access and validate continuous event delivery. Which continuing safeguard BEST prevents the same control weakness from returning?
Explanation
Correct Answer
The recurring safeguard is: Test SQL auditing destinations after storage permission or network changes. This mitigates the control weakness because: Audit policy presence does not prove that authorized log records are successfully stored. Keep the intervention, Correct audit destination access and validate continuous event delivery., in the approved deployment, monitoring and change governance process.
Incorrect Answers
“Review VM security type and secure boot configuration during image approval” addresses a different recurring failure: A secure capable VM must have applicable firmware and security settings enabled for boot integrity checks. For the condition in this question, maintain “Test SQL auditing destinations after storage permission or network changes” because audit policy presence does not prove that authorized log records are successfully stored.
This safeguard is for the dependency described by: Server HTTPS encryption and client certificate authentication establish different trust properties. The continuing risk here is determined by: Audit policy presence does not prove that authorized log records are successfully stored. The targeted safeguard is “Test SQL auditing destinations after storage permission or network changes”.
“Review signed access permissions against actual workload operations” addresses a different recurring failure: Data access should reflect precise blob type, resource path, and allowed operations. For the condition in this question, maintain “Test SQL auditing destinations after storage permission or network changes” because audit policy presence does not prove that authorized log records are successfully stored.