You have an Azure Synapse Analytics dedicated SQL pool named pool1. You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative…

The correct answer is C. sensitivity labels. Microsoft Defender for SQL is a tool that provides advanced SQL security capabilities, including vulnerability assessment, threat protection, and detection of anomalous activities that may indicate a security threat to your databases. However, for the specific need of auditing…

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

Question

You have an Azure Synapse Analytics dedicated SQL pool named pool1. You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort. What should you include in the solution?

Options

AMicrosoft Defender for SQL
Bdynamic data masking
Csensitivity labels
Dworkload management

How the community answered

(21 responses)

A
5% (1)
B
5% (1)
C
76% (16)
D
14% (3)

Explanation

Microsoft Defender for SQL is a tool that provides advanced SQL security capabilities, including vulnerability assessment, threat protection, and detection of anomalous activities that may indicate a security threat to your databases. However, for the specific need of auditing SQL statements affecting sensitive data, sensitivity labels are the more directly applicable feature.

Topics

#sensitivity labels#SQL audit#dedicated SQL pool#data classification

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice