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 9 months, 2 weeks 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

5 months, 2 weeks 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

5 months, 2 weeks 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

9 months, 2 weeks 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

...

SylUK

Most Recent 5 months 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 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

5 months, 1 week 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

7 months, 1 week 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

8 months, 2 weeks 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

9 months, 3 weeks ago

Both, define the relationship as active

upvoted 1 times

kamalagarashova

8 months, 2 weeks ago

correction: single, Delete the many to one relationship

upvoted 2 times

...

rcaliandro

9 months, 3 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

9 months, 3 weeks ago

Answer should be None, Delete the many to one relationship

upvoted 2 times

Tex02

9 months, 3 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

9 months, 3 weeks ago

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

upvoted 3 times

desibaby09

6 months, 3 weeks ago

you are misleading giving out wrong information

upvoted 1 times

...