You have a new Azure SQL database.

Microsoft DP-300 Question Answer

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).

DP-300 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"