A company has an Azure SQL Database that contains sensitive financial data. The compliance team requires that all UPDATE statements on the 'Transactions' table be audited. The administrator has already configured a server-level audit. What should the administrator do to meet the requirement?

Create a database-level audit specification that audits UPDATE on the Transactions table.

Configure the server-level audit to audit all UPDATE statements on all tables.

Enable change tracking on the Transactions table to track updates.

Create a trigger that logs UPDATE statements to a custom table.

A company has an Azure SQL Database that contains personally identifiable information (PII). The compliance team requires that all SELECT statements on a specific table be logged for auditing. The administrator has already configured a server-level audit that writes to a storage account. What should the administrator do to meet the requirement?

Enable a database-level audit and configure it to audit SELECT statements on the specific table.

Enable change tracking on the table to log all SELECT statements.

Create a trigger that logs SELECT statements to a custom table.

Configure the server-level audit to audit all SELECT statements on all tables.

You are setting up database-level auditing for an Azure SQL database. Which T-SQL statement do you use to create a database audit specification?

CREATE SERVER AUDIT SPECIFICATION

CREATE DATABASE AUDIT SPECIFICATION

Microsoft Certified:Azure Database Administrator Associate

Domain 2Objective 3

Implement Compliance Controls for Sensitive Data DP-300 Practice Questions (Page 6)

Part of the Implement a secure environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here

6free pages

7concepts

20–25%of the exam

Questions 26–29

26application · medium
A company has an Azure SQL Database that contains sensitive financial data. The compliance team requires that all UPDATE statements on the 'Transactions' table be audited. The administrator has already configured a server-level audit. What should the administrator do to meet the requirement?
Select an answer first
27foundation · easy
You need to track which rows have changed in an Azure SQL database table so that an external process can synchronize changes. Which feature should you implement?
Select an answer first
28application · medium
A company has an Azure SQL Database that contains personally identifiable information (PII). The compliance team requires that all SELECT statements on a specific table be logged for auditing. The administrator has already configured a server-level audit that writes to a storage account. What should the administrator do to meet the requirement?
Select an answer first
29foundation · easy
You are setting up database-level auditing for an Azure SQL database. Which T-SQL statement do you use to create a database audit specification?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Implement Compliance Controls for Sensitive Data DP-300 Practice Questions (Page 6)

Questions 26–29

A company has an Azure SQL Database that contains sensitive financial data. The compliance team requires that all UPDATE statements on the 'Transactions' table be audited. The administrator has already configured a server-level audit. What should the administrator do to meet the requirement?

You need to track which rows have changed in an Azure SQL database table so that an external process can synchronize changes. Which feature should you implement?

You are setting up database-level auditing for an Azure SQL database. Which T-SQL statement do you use to create a database audit specification?

Keep studying — Implement a secure environment