ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 23 discussion

Actual exam question from Microsoft's PL-300
Question #: 23
Topic #: 2
[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?

  • 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 Hide Answer
Suggested Answer: B 🗳️
by Namenick10 at Sept. 21, 2022, 2:03 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Dr_Do
Highly Voted 2 years, 4 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, 7 months ago
Selected Answer: B
Answer is B
upvoted 19 times
...
Srilatha_B
Most Recent 4 months ago
Selected Answer: B
https://www.youtube.com/watch?v=dXJ9MYJ1qMo
upvoted 1 times
...
jaume
5 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
8 months, 2 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
9 months, 1 week ago
correct answer
upvoted 1 times
...
LL_Seva
1 year 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, 2 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
MayurV19
1 year, 4 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, 4 months ago
Selected Answer: B
B is the correct answer.
upvoted 1 times
...
Igetmyrole
1 year, 7 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
1 year, 9 months 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 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, 3 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
...
chellyAh
2 years, 4 months ago
Selected Answer: B
Answer is B
upvoted 1 times
...
lukelin08
2 years, 6 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
mahtab
2 years, 7 months ago
B is correct
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago