Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DA-100 Topic 18 Question 15 Discussion

Actual exam question for Microsoft's DA-100 exam
Question #: 15
Topic #: 18
[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?

Show Suggested Answer Hide 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.

Contribute your Thoughts:

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

Save Cancel