Question about multiple role setting

[Sophiecyj]

Hi team,

I am studying PL-300 test and saw the below question with a given answer D. Could you help me to verify if it is A or D?

I actually tried by myself to create two roles and assing the rules to each of them as Role 1: Brand ="JD", Role 2: Year = "2023". However after assing myself to both the two roles, instead of only seeing the data of 2023 JD, I can see all the data, based on which I feel like the answer for this question should be A. I am only able to the data of 2023 JD if I put both Brand ="JD" and Year = "2023" under the same role.

Thanks!

[fahadqadir3 · Accepted solution]

@Sophiecyj Correct Answer A. Two Roles 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

When a report user is assigned to multiple roles, RLS filters become additive which meas the user can see State Province value is Kentucky or the Calendar Year is 2020. 

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

[Sophiecyj]

Thanks mate!!