Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 2 question 8 discussion

Actual exam question from Microsoft's DA-100

Question #: 8
Topic #: 2

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and
Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.

Date[Calendar Year] = 2020 -
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

A. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
B. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
C. The user will see only data for which the State Province value is Kentucky.
D. The user will receive an error and will not be able to see the data in the report.

Show Suggested Answer

Suggested Answer: B 🗳️

by Evert23 at Oct. 2, 2020, 10:41 a.m.

Comments

Submit Cancel

Evert23

Highly Voted 4 years, 10 months ago

Correct!

upvoted 121 times

Stalin77

4 years ago

OR CONDITION

upvoted 7 times

...

mirzotti

3 years, 7 months ago

On exam 21-12-2021. I answered OR

upvoted 5 times

...

vinothravi

Highly Voted 4 years, 10 months ago

A.user will see data for which the State Province value is Kentucky and the Calendar Year is 2020

upvoted 24 times

Wayne951221

3 years, 9 months ago

This is wrong

upvoted 4 times

...

eurekamike

4 years ago

when you use "and" that means there are more conditions to meet and less data is available. "or" means that you have more access to data. role 1 can see any data from kentucky from any year. role 2 can see any data from 2020 from any state. if you say only kentucky and 2020 then you have limited your data. role permissions are additive, not restrictive.

upvoted 41 times

eurekamike

4 years ago

kentucky or 2020: |2018|2019|2020 Virginia| |no | no | yes kentucky |yes |yes | yes Mississippi |no | no | yes Florida |no | no |yes kentucky and 2020: |2018|2019|2020 Virginia| |no | no | no kentucky |no |no | yes Mississippi |no | no | no Florida |no | no |no

upvoted 32 times

BanderMansor

3 years, 7 months ago

Thanks Amazing example!

upvoted 4 times

...

blumek

Most Recent 2 years, 7 months ago

Answer seems should be B https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

upvoted 1 times

...

Amine09

2 years, 9 months ago

at the level of the last version of the PL-300, we find the answer A, because we have at the level of the question (RLS) roles named Role1 and Role2

upvoted 1 times

...

pimni

3 years, 1 month ago

B is correct

upvoted 2 times

...

Mona00

3 years, 2 months ago

Selected Answer: B

B is corrct

upvoted 2 times

...

Bhushan_M

3 years, 2 months ago

Tested, its OR. If user is part of two roles then the tables will be additive and OR condition will be appiled

upvoted 3 times

...

JO4LIVE

3 years, 4 months ago

on exam 09/04/22

upvoted 1 times

...

Chris610

3 years, 4 months ago

Selected Answer: B

Answer seems should be B https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

upvoted 2 times

...

Lollipop14527

3 years, 5 months ago

Correct, it's B. The other possible solution would've been D if one of the tables (dates or city) came from a different source (the limited relationship issue with multiple RLS roles).

upvoted 2 times

...

Ashley090521

3 years, 5 months ago

on exam 3/1/2022

upvoted 1 times

...

nickname_1994

3 years, 5 months ago

Yes, answer is correct (B). I tested. If you would describe RLS in DAX as AND(City[ProvinceState] = "Kentucky", Date[Year] = 2020), then you would get A answer. It would be filtered by both conditions.

upvoted 2 times

...

mongolian7

3 years, 6 months ago

Selected Answer: B

The answer B is correct. "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." (from https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance)

upvoted 1 times

...