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…

The correct answer is B. SQL Server audit C. database audit specification. Auditing an instance of SQL Server or a SQL Server database involves tracking and logging events that occur on the system. The SQL Server Audit object collects a single instance of server-level or database-level actions and groups of actions to monitor. The audit is at the SQL…

Submitted by diego_uy· Mar 6, 2026Implement a secure environment

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.

Options

Aserver audit specification
BSQL Server audit
Cdatabase audit specification
Da server principal

How the community answered

(24 responses)

A
8% (2)
B
75% (18)
D
17% (4)

Explanation

Auditing an instance of SQL Server or a SQL Server database involves tracking and logging events that occur on the system. The SQL Server Audit object collects a single instance of server-level or database-level actions and groups of actions to monitor. The audit is at the SQL Server instance level. You can have multiple audits per SQL Server instance. The Database- Level Audit Specification object belongs to an audit. You can create one database audit specification per SQL Server database per audit. https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit- and-database-audit-specification

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice