70-473 · Question #68
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might h
The correct answer is B. No. Creating a Database Audit Specification in the master database will only audit events within the master database and does not define where the audit information is written.
Question
Options
- AYes
- BNo
How the community answered
(18 responses)- A11% (2)
- B89% (16)
Why each option
Creating a Database Audit Specification in the master database will only audit events within the master database and does not define where the audit information is written.
A Database Audit Specification configured in the master database will only capture SELECT statements executed against objects within the master database, failing to meet the requirement to audit all databases on the instance.
Concept tested: SQL Server Database Audit Specification scope
Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-level-action-groups-and-actions
Topics
Community Discussion
No community discussion yet for this question.