Microsoft Exam DA-100 Topic 18 Question 15 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 15
Topic #: 18

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?

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

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

CThe user will see only data for which the State Province value is Kentucky.

DThe user will receive an error and will not be able to see the data in the report.

Show Suggested Answer

Suggested Answer: B

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.

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

by Selma at May 09, 2022, 06:00 AM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!