nerdexam
Microsoft

DP-203 · Question #73

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?

The correct answer is C. sensitivity classifications. 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…

Submitted by satoshi_tk· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

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?

Options

  • Adynamic data masking
  • Brow-level security (RLS)
  • Csensitivity classifications
  • Dcolumn-level security

How the community answered

(33 responses)
  • A
    9% (3)
  • B
    6% (2)
  • C
    82% (27)
  • D
    3% (1)

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. https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-

Topics

#sensitivity classifications#PII auditing#data governance#Synapse SQL pool

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice