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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 1 Question 71 Discussion

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.What should you do?
D) Create an active relationship between the tables and select Apply security filter in both directions.
A) Create an active relationship between the tables and select Assume referential integrity.
B) Create an inactive relationship between the tables and select Assume referential integrity.
C) Create an inactive relationship between the tables and select Apply security filter in both directions.

Microsoft PL-300 Exam - Topic 1 Question 71 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 71
Topic #: 1
[All PL-300 Questions]

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: D

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.


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

by Jodi at Aug 03, 2025, 12:34 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Micaela
7 months ago
Definitely need to apply security filters in both directions!
upvoted 0 times
...
Norah
8 months ago
Wait, can you really use inactive relationships for this?
upvoted 0 times
...
Chantell
8 months ago
Option C is the way to go for RLS!
upvoted 0 times
...
Lina
8 months ago
I think D makes more sense, though.
upvoted 0 times
...
Inocencia
8 months ago
Assume referential integrity? Not sure about that one.
upvoted 0 times
...
Desiree
8 months ago
I believe we should go with option D, creating an active relationship and applying security filters in both directions. That seems to align with what I studied about RLS.
upvoted 0 times
...
Talia
9 months ago
I'm a bit confused about the difference between active and inactive relationships in this context. I thought inactive ones could still work with RLS if set up correctly.
upvoted 0 times
...
Junita
9 months ago
I remember practicing a similar question where we had to ensure RLS worked correctly. I feel like option C might be the right choice since it mentions applying security filters.
upvoted 0 times
...
Deja
9 months ago
I think we need to create an active relationship, but I'm not sure if we should select "Assume referential integrity" or "Apply security filter in both directions."
upvoted 0 times
...
Tom
9 months ago
Confident I can solve this. The solution is to create an inactive relationship and select "Apply security filter in both directions" to ensure the RLS settings are respected.
upvoted 0 times
...
Felicidad
9 months ago
I think the answer is C - creating an inactive relationship and selecting "Apply security filter in both directions". That seems like the best way to honor the RLS settings.
upvoted 0 times
...
Jina
10 months ago
Hmm, I'm a bit unsure about the difference between active and inactive relationships. I'll need to refresh my memory on that before deciding.
upvoted 0 times
...
Evan
10 months ago
Okay, let me think this through. The key is ensuring the bidirectional cross-filtering honors the RLS settings, so I'll need to focus on that.
upvoted 0 times
...
Ahmed
10 months ago
This looks like a tricky one. I'll need to carefully review the options to ensure I understand the implications of each approach.
upvoted 0 times
...
Claribel
10 months ago
Hmm, applying security filters in both directions sounds like the right approach to me. Can't have any security leaks, you know?
upvoted 0 times
...
Kathrine
10 months ago
I'm not sure, but I think it's between A and B.
upvoted 0 times
...
Stephen
12 months ago
I disagree, I believe the correct answer is C.
upvoted 0 times
...
Matt
12 months ago
Option C looks like the way to go. Gotta make sure that security filters are applied in both directions to honor the RLS settings.
upvoted 0 times
Sharee
10 months ago
Creating an inactive relationship and selecting Apply security filter in both directions seems like the right approach to maintain the RLS settings.
upvoted 0 times
...
Nydia
10 months ago
I agree, it's crucial to make sure the RLS settings are respected when creating the relationship between the tables.
upvoted 0 times
...
Kaycee
11 months ago
I think option C is the best choice. Applying security filters in both directions is important for honoring the RLS settings.
upvoted 0 times
...
...
Maxima
1 year ago
I think the answer is D.
upvoted 0 times
...

Save Cancel