ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 2 question 8 discussion

Actual exam question from Microsoft's DA-100
Question #: 8
Topic #: 2
[All DA-100 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
by Evert23 at Oct. 2, 2020, 10:41 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Evert23
Highly Voted 4 years, 6 months ago
Correct!
upvoted 121 times
Stalin77
3 years, 8 months ago
OR CONDITION
upvoted 7 times
...
mirzotti
3 years, 4 months ago
On exam 21-12-2021. I answered OR
upvoted 5 times
...
...
vinothravi
Highly Voted 4 years, 6 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, 5 months ago
This is wrong
upvoted 4 times
...
eurekamike
3 years, 8 months 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
3 years, 8 months 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, 3 months ago
Thanks Amazing example!
upvoted 4 times
...
...
...
...
blumek
Most Recent 2 years, 3 months ago
Answer seems should be B https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
upvoted 1 times
...
Amine09
2 years, 6 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
2 years, 9 months ago
B is correct
upvoted 2 times
...
Mona00
2 years, 10 months ago
Selected Answer: B
B is corrct
upvoted 2 times
...
Bhushan_M
2 years, 11 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 ago
on exam 09/04/22
upvoted 1 times
...
Chris610
3 years, 1 month 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, 1 month 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, 1 month ago
on exam 3/1/2022
upvoted 1 times
...
nickname_1994
3 years, 2 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, 2 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
...
Nurgul
3 years, 2 months ago
Selected Answer: A
The answer is A.
upvoted 1 times
Nurgul
3 years, 2 months ago
Sorry, A is not correct. The correct answer is B. I've tested.
upvoted 2 times
...
...
kwanalytics
3 years, 4 months ago
On exam Dec. 27, 2021 - answered AND but believe it's actually OR.
upvoted 2 times
...
MustPassDA100
3 years, 4 months ago
on exam 12/25/2021, and I chose 'or'
upvoted 1 times
...
aguilartu1
3 years, 5 months ago
on exam - Nov 11, 2021. my answer: The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
upvoted 6 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago