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…

Question

Exhibit

Options

• ATurn on auditing and write audit logs to an Azure Storage account.
• BAdd extended properties to the column.
• CTurn on Advanced Data Security for the Azure SQL server.
• DApply sensitivity labels named Highly Confidential to the column.
• ETurn on Azure Advanced Threat Protection (ATP).

• A
  46% (21)
• B
  17% (8)
• E
  37% (17)

Explanation

C: Advanced Data Security (ADS) is a unified package for advanced SQL security capabilities. ADS is available for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It includes functionality for discovering and classifying sensitive data D: You can apply sensitivity-classification labels persistently to columns by using new metadata attributes that have been added to the SQL Server database engine. This metadata can then be used for advanced, sensitivity-based auditing and protection scenarios. A: An important aspect of the information-protection paradigm is the ability to monitor access to sensitive data. Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query. Here's an example: https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-

No community discussion yet for this question.