Question 310
An Azure SQL operations team investigates: A test SQL connection is denied and the monitoring team needs to verify whether the approved audit events were captured. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A test SQL connection is denied and the monitoring team needs to verify whether the approved audit events were captured. The specific supported administrative response is: Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls. The technical risk is: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. Confirm the correction with: A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp.
The acceptance evidence for this incident (A test SQL connection is denied and the monitoring team needs to verify whether the approved audit events were captured.) is: A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp. It directly tests whether the remediation (Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Contained database users from entra identities (2.1) would demonstrate or implement: The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions. This case instead tests SQL database auditing and audit storage (2.3); the choice measures or changes another part of the system.
Managed identity database access (2.1) addresses another technical failure: Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely. The required paired action and test concerns SQL database auditing and audit storage (2.3); a passing result for this alternative could leave that requirement unresolved.
Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The paired-answer requirement concerns SQL database auditing and audit storage (2.3); this alternative does not provide the matching intervention and separate acceptance evidence.