Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 94 discussion

Actual exam question from Microsoft's PL-300

Question #: 94
Topic #: 2

HOTSPOT -

You have a Power BI semantic model that contains two tables as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Endeetheanalyst at Sept. 5, 2024, 1:30 p.m.

Comments

Submit Cancel

b92fc92

Highly Voted 10 months, 1 week ago

1. Single 2. Delete the many to one relationship, because the question asks what do you have to do first, if you set the relationship active as first step, you will receive an error message, because there would be 2 active relationship with the same 2 tables

upvoted 12 times

Odidepse

6 months ago

First is correct, I think second one should be Change cross-filter direction (to both) as the first step as required. Deleting many to one relationship could be necessary on specific scenarios to resolve errors, but before you could do this, first step is to enable bi directional filtering which means Change the cross-filter direction to "Both", same also with Define the relationship as active, cant do this unless you change the hange cross-filter direction and set it to both to enable bi-directional filtering. Once you Change cross-filter direction to "Both" that is the only time you can efine the relationship as active or removing delete many-to-one relationships if it gives exception error.

upvoted 1 times

...

esrath

6 months, 1 week ago

1. Single, because 1-many or many-1 only supports (Single and Both). - https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#cross-filter-direction 2. You must FIRST make the active relationship "Inactive". Since that option is not available here, the "Delete the many-to-one relationship" option should be correct as the first step. Note that if you Define the many-many relationship as active first, it will give an error.

upvoted 1 times

...

b92fc92

10 months, 1 week ago

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand "There can only be one active filter propagation path between two model tables."

upvoted 1 times

...

Lulu_2022

Most Recent 2 weeks, 2 days ago

Many-to-one relationships (e.g., from a fact table to a dimension table) default to single-directional filtering — from the one-side to the many-side. This is the most common and performance-friendly setup. For many-to-many relationships, enabling bi-directional filtering is possible, but to make it compatible with RLS, you must explicitly change the cross filter direction and enable the security filtering behavior in the relationship settings.

upvoted 1 times

...

SylUK

5 months, 3 weeks ago

The answer is correct: Single and Define the relationship as active. For the second answer: we can see that only the many-to-one relationship is active and many-to-many disable. So when we ENABLE bi-directional filtering, it means that we are defining that relationship as active and therefore the many-to-one relationship is not relevant anymore so we delete it. This is my opinion.

upvoted 1 times

SylUK

5 months, 3 weeks ago

In other terms, when you firstly define the relationship active it simply means that you deleted the many-to-one relationship considering the example in the exhibit, and therefore enable the many-to-many filtering.

upvoted 1 times

...

627628c

6 months ago

1: Single 2. Delete the many to one. Per MS Learn, you should first make the other relationship inactive. Since making it inactive is not an option, we must delete: "To ensure there’s a default relationship, Power BI Desktop allows only a single active relationship between two tables at a given time. Therefore, you must first set the current relationship as inactive and then set the relationship you want to be active." https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

upvoted 1 times

...

jaume

8 months ago

1.- Single 2.- Define the relationship as active. This would set the other relationship to inactive but this is not a constraint for this question

upvoted 3 times

...

ec338ed

9 months ago

Both answers are correct. Only active relationships can participate in filtering and RLS, so if it’s currently inactive, you need to activate the relationship.

upvoted 1 times

...

kamalagarashova

10 months, 2 weeks ago

Both, define the relationship as active

upvoted 1 times

kamalagarashova

9 months, 1 week ago

correction: single, Delete the many to one relationship

upvoted 2 times

...

rcaliandro

10 months, 2 weeks ago

Answer is right the many-to-one relationship is single and we need first to remove the many-to-many relationship

upvoted 4 times

...

Endeetheanalyst

10 months, 2 weeks ago

Answer should be None, Delete the many to one relationship

upvoted 2 times

Tex02

10 months, 2 weeks ago

Are you sure about this - when I look at my models in Power BI the single arrow in the 1 to many relationship means it is single, the double arrow means it is both. To enable the filtering the relationship must be active in the many-to-many.

upvoted 3 times

...

Endeetheanalyst

10 months, 2 weeks ago

Who is answering this question for Examtopics please? Your answers are so misleading

upvoted 3 times

desibaby09

7 months, 2 weeks ago

you are misleading giving out wrong information

upvoted 1 times

...