What should you include in the solution?

You are designing an Azure Synapse Analytics dedicated SQL pool.

You need to ensure that you can audit access to Personally Identifiable information (PII).

What should you include in the solution?
A . dynamic data masking
B . row-level security (RLS)
C . sensitivity classifications
D . column-level security

View Answer

Answer: C

Explanation:

Data Discovery & Classification is built into Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It provides basic capabilities for discovering, classifying, labeling, and reporting the sensitive data in your databases.

Your most sensitive data might include business, financial, healthcare, or personal information. Discovering and classifying this data can play a pivotal role in your organization’s information-protection approach.

It can serve as infrastructure for:

✑ Helping to meet standards for data privacy and requirements for regulatory compliance.

✑ Various security scenarios, such as monitoring (auditing) access to sensitive data.

✑ Controlling access to and hardening the security of databases that contain highly sensitive data.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview