A DBA disables server auditing on the lock-lab SQL server “because the water-quality database already has its own audit.” What is the correct guidance?
Select an answer to reveal the explanation.
Short Explanation
Database audit is an extra camera in one room. Server audit is the building system—don’t rip out the building cameras because one lab already has a webcam.
Full Explanation
Server-level and database-level auditing scopes are additive. A database audit supplements detail for that database; it does not remove the need for server-level auditing when the goal is consistent coverage across the logical server or managed instance. Masking and NSG flow logs address different controls and are not substitutes for SQL auditing.