DP-300 Certification Practice Question #121

Question

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.

Accepted Answer

To audit queries (SELECT statements) on a specific table (`CustomerPII` in `DB1`) in a SQL Server instance running on an Azure virtual machine, you must configure SQL Server Auditing. This process requires two components. First, you must configure a SQL Server Audit (Option B) at the instance level to define the target destination for audit logs (e.g., a file or event log). Second, you must configure a Database Audit Specification (Option C) within `DB1` that defines the table-level action to audit (SELECT on `CustomerPII`) and links it to the server audit.

More DP-300 practice questions