Exam PL-300 topic 2 question 15 discussion

Wrong , correct answer is A

Answer should be A, from the Microsoft documentation (https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance): "When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters." This means that you would see all data where either Role1 OR Role2 applies, so the answer is A not D.

"If a user is a member of both Role1 and Role2" IT USES THE WORD AND WHICH WILL ALLOW THEM TO SEE BOTH!

D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020. Explanation In Power BI, when a user is assigned to multiple Row-Level Security (RLS) roles, the filters from those roles are combined with an AND condition. This means that all filters must apply simultaneously. Role1 Filter: City[State Province] = "Kentucky" This restricts the data to only rows where the State Province is "Kentucky." Role2 Filter: Date[Calendar Year] = 2020 This restricts the data to only rows where the Calendar Year is 2020. Since the user is a member of both roles, both conditions will apply together. Therefore, the user will see only data that meets both of these criteria: The State Province is Kentucky. The Calendar Year is 2020. Hence, Option D is the correct answer

combined with an AND relationship

Chat GPT confirmed as well

From Role 1, user is restricted to data where City[State Province] = "Kentucky" From Role 2, user is restricted to data where Date[CalendarYear] = "2020" It cannot happen user can reach some data in the report out of "Kentucky" State because it's dated "2020" and also cannot see any data for Kentucky from other year than "2020" so I vote here for answer D

If you have selected A: What if a record belongs to Kentucky but other province records are present in 2020. Creates ambiguity right? I think D should be correct.

Option A

option D is correct based on the this link

its simple, Rule1 and Rule2 applied meaning, Rule1 AND Rule2. D is the correct answer

Of course D- The user will only see data for which the State Province value is Kentucky AND the Calendar Year is 2020

D is correct. Additive means AND.

I think in a nutshell, at any point in time user can view the report as SINGLE role. Hence if the user viewing as ROLE1 then City rule would apply, otherwise if the user viewing as ROLE2 year rule would apply. hence the answer is A (which mean the user has option to view as both roles independently).

The right answer is A. the user will see RLS 1 or RLS 2. It's a little confusing for some people as they might understand the statement as: RLS 1 AND (not RLS 2) and vice versa. However, "OR" here is like logical operators. They can see, only rows belong to RLS1, only rows belong to RLS 2 and their intersect (both RLS1 & RLS2). In other word, in this case, users can see all [State Province] in 2020, as well as Kentucky through out all [Calendar Year].

correct answer

https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance