Which two options should you enable?

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.

You need to record whenever users query the CustomerPII table.

Which two options should you enable? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . server audit specification
B . SQL Server audit
C . database audit specification
D . a server principal

View Answer

Answer: A,C

Explanation:

An auditing policy can be defined for a specific database or as a default server policy in Azure (which hosts SQL Database or Azure Synapse):

✑ A server policy applies to all existing and newly created databases on the server.

✑ If server auditing is enabled, it always applies to the database. The database will

be audited, regardless of the database auditing settings.

✑ Enabling auditing on the database, in addition to enabling it on the server, does not override or change any of the settings of the server auditing. Both audits will exist side by side. NOTE:

The Server Audit Specification object belongs to an audit.

A Database Audit Specification defines which Audit Action Groups will be audited for the specific database in which the specification is created.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview