Administering Relational Databases on Microsoft Azure (DP-300) Test 2

Question : 6 of 40

Marks: +1, -0

03 - Implement a Secure Environment
QUESTION 1
You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored
for 365 days from the date the query was executed. Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Turn on auditing and write audit logs to an Azure Storage account.
Add extended properties to the column.
Turn on Advanced Data Security for the Azure SQL server.
Apply sensitivity labels named Highly Confidential to the column.
Turn on Azure Advanced Threat Protection (ATP).

Validate

Go to Question:

Prev Question

Next Question