You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use

The correct answer is A. column-level security. Column-level security simplifies the design and coding of security in your application, allowing you to restrict column access to protect sensitive data. For example, ensuring that specific users can access only certain columns of a table pertinent to their department.

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

Question

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use?

Options

Acolumn-level security
Brow-level security (RLS)
CTransparent Data Encryption (TOE)
Ddynamic data masking

How the community answered

(24 responses)

A
75% (18)
B
8% (2)
C
13% (3)
D
4% (1)

Explanation

Column-level security simplifies the design and coding of security in your application, allowing you to restrict column access to protect sensitive data. For example, ensuring that specific users can access only certain columns of a table pertinent to their department.

Topics

#column-level security#dynamic data masking#dedicated SQL pool#access control

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice