Microsoft PL-300 Exam - Topic 1 Question 71 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 71
Topic #: 1

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?

ACreate an active relationship between the tables and select Assume referential integrity.

BCreate an inactive relationship between the tables and select Assume referential integrity.

CCreate an inactive relationship between the tables and select Apply security filter in both directions.

DCreate an active relationship between the tables and select Apply security filter in both directions.

Show Suggested 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:

Submit Cancel

Micaela

5 months ago

Definitely need to apply security filters in both directions!

upvoted 0 times

...

Norah

5 months ago

Wait, can you really use inactive relationships for this?

upvoted 0 times

...

Chantell

5 months ago

Option C is the way to go for RLS!

upvoted 0 times

...

Lina

6 months ago

I think D makes more sense, though.

upvoted 0 times

...

Inocencia

6 months ago

Assume referential integrity? Not sure about that one.

upvoted 0 times

...

Desiree

6 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

6 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

6 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

7 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

7 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

7 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

...