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 94 discussion

Actual exam question from Microsoft's PL-300
Question #: 94
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer:
by Endeetheanalyst at Sept. 5, 2024, 1:30 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
b92fc92
Highly Voted 5 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
1 month 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
1 month, 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
5 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
...
...
SylUK
Most Recent 3 weeks, 1 day 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
3 weeks, 1 day 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
1 month 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
3 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
4 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
5 months, 2 weeks ago
Both, define the relationship as active
upvoted 1 times
kamalagarashova
4 months, 1 week ago
correction: single, Delete the many to one relationship
upvoted 2 times
...
...
rcaliandro
5 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
5 months, 2 weeks ago
Answer should be None, Delete the many to one relationship
upvoted 1 times
Tex02
5 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
5 months, 2 weeks ago
Who is answering this question for Examtopics please? Your answers are so misleading
upvoted 3 times
desibaby09
2 months, 2 weeks ago
you are misleading giving out wrong information
upvoted 1 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