Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 23 discussion

Actual exam question from Microsoft's PL-300

Question #: 23
Topic #: 2

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?

A. Create an inactive relationship between the tables and select Apply security filter in both directions.
B. Create an active relationship between the tables and select Apply security filter in both directions.
C. Create an inactive relationship between the tables and select Assume referential integrity.
D. Create an active relationship between the tables and select Assume referential integrity.

Show Suggested Answer

Suggested Answer: B 🗳️

by Namenick10 at Sept. 21, 2022, 2:03 p.m.

Comments

Submit Cancel

Dr_Do

Highly Voted 2 years, 7 months ago

Selected Answer: B

No point of discussion. RLS works through ACTIVE links, so inactive will simply no work!

upvoted 29 times

...

Namenick10

Highly Voted 2 years, 10 months ago

Selected Answer: B

Answer is B

upvoted 19 times

...

Srilatha_B

Most Recent 7 months, 1 week ago

Selected Answer: B

https://www.youtube.com/watch?v=dXJ9MYJ1qMo

upvoted 1 times

...

jaume

8 months, 2 weeks ago

Selected Answer: B

Also voting for B solution and with detailed explanation from MayurV19 ("RLS only works with active relationships. So, there is no question of building inactive relationships here. Also, we have the set the bi-directional filtering as expected and asked in the question"

upvoted 1 times

...

rcaliandro

11 months, 3 weeks ago

Selected Answer: B

I totally agree with you, guys! B - Create an active relationship between the tables and select Apply security filter in both directions

upvoted 1 times

...

Kiran37

1 year ago

correct answer

upvoted 1 times

...

LL_Seva

1 year, 3 months ago

Selected Answer: B

I passed the exam on 5 April 2024 (906/1000). My answer was: B

upvoted 5 times

...

LL_Seva

1 year, 5 months ago

Selected Answer: B

B is the answer

upvoted 1 times

...

MayurV19

1 year, 7 months ago

Correct answer. RLS only works with active relationships. So, there is no question of building inactive relationships here. Also, we have the set the bi-directional filtering as expected and asked in the question.

upvoted 1 times

...

Dsbuff

1 year, 7 months ago

Selected Answer: B

B is the correct answer.

upvoted 1 times

...

Igetmyrole

1 year, 11 months ago

B is the correct answer. It enables the bidirectional cross-filtering and respects the RLS settings, ensuring that data in both tables is filtered based on the RLS rules applied to the user.

upvoted 1 times

...

SamuComqi

2 years ago

Selected Answer: B

I passed the exam today (948/1000). My answer was: - Create an active relationship between the tables and select Apply security filter in both directions

upvoted 11 times

...

RazaTheLegend

2 years, 3 months ago

Selected Answer: B

B Is the answer. By default RLS has single direction filter but we should create both directional filter and check mark the apply security filter in both directions

upvoted 3 times

...

yordiye

2 years, 6 months ago

B Is the answer. By default RLS has single direction filter but we should create both directional filter and check mark the apply security filter in both directions

upvoted 1 times

...