Microsoft
DP-203 · Question #302
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table named Sales. Sales has row-level security (RLS) applied. RLS uses the following predicate filter. A user…
The correct answer is D. only the rows for which the value in the SalesRep column is SalesUser1. https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql- server-ver16#Typical
Submitted by asante_acc· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table named Sales. Sales has row-level security (RLS) applied. RLS uses the following predicate filter. A user named SalesUser1 is assigned the db_datareader role for Pool1. Which rows in the Sales table are returned when SalesUser1 queries the table?
Exhibit
Options
- Aonly the rows for which the value in the User_Name column is SalesUser1
- Ball the rows
- Conly the rows for which the value in the SalesRep column is Manager
- Donly the rows for which the value in the SalesRep column is SalesUser1
How the community answered
(56 responses)- A5% (3)
- B14% (8)
- C7% (4)
- D73% (41)
Explanation
https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql- server-ver16#Typical
Topics
#row-level security#RLS#predicate filter#dedicated SQL pool
Community Discussion
No community discussion yet for this question.