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

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

DRAG DROP -
You create a data model in Power BI.
Report developers and users provide feedback that the data model is too complex.
The model contains the following tables.

The model has the following relationships:
✑ There is a one-to-one relationship between Sales_Region and Region_Manager.
✑ There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
✑ There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.
You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
by sylesh at Sept. 11, 2022, 8:55 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
Nurgul
Highly Voted 2 years, 6 months ago
1.Merge [Region_Manager] and [Manager] by using an inner join. 3.Merge [Sales_Region] and [Sales_Manager] by using an inner join. 6.Merge [Sales_Region] and [Region_Manager] by using an inner join.
upvoted 167 times
FinelogBiseum
1 year ago
Approved
upvoted 2 times
...
Time2excel
1 year, 9 months ago
you are an absolute genius!
upvoted 8 times
...
GabryPL
2 years, 3 months ago
Ok but what about 3,1,6. It will be the same
upvoted 4 times
...
md_sultan
2 years, 4 months ago
I just have a query if we have selected first 6 ,3,1 then am I going to get less points here?
upvoted 1 times
TestPB
2 years, 4 months ago
Question states "You need to denormalize the model into a single table." sequence 1,3,6 would merge everything into a single table.... but 6,3,1 will have 2 tables.. so sequence 1,3,6 is correct
upvoted 7 times
Nemesizz
2 years, 2 months ago
Why two tables? I dont get it
upvoted 1 times
...
md_sultan
2 years, 3 months ago
TestBP, can you plz elaborate , i am not able to understand how 2 table and 1 table will be created
upvoted 1 times
...
...
Allen879385
2 years, 4 months ago
me too
upvoted 1 times
...
semauni
2 years ago
I think so, though the question states that more than one order is correct. 6 merges the two smaller tables, I think it is better to merge the larger tables first, because that means the last inner join will have less rows to fuse.
upvoted 3 times
semauni
2 years ago
So I think 1-3-6 is an option, 3-1-6 as well, but starting with 6 is not.
upvoted 2 times
...
...
Load full discussion...
...
Load full discussion...
...
sylesh
Highly Voted 2 years, 7 months ago
I think the last query in the answer should be "Merge [sales_region] and [region_manager] using an inner join" . Outer join may exclude some records for which region_manager info might be absent.
upvoted 20 times
NevilleV
2 years, 6 months ago
That did my head in and took at least 20 min to fathom out. In the end, I agree with this answer. I hope I can do it MUCH quicker in the exam.
upvoted 8 times
lukelin08
2 years, 5 months ago
What did you decide was the correct answer?
upvoted 1 times
...
...
RickyAnd
2 years, 7 months ago
exactly, I agree
upvoted 2 times
...
Lewiasskick
2 years, 6 months ago
The sales Region and Region manager has one to one relationship, therefore, it does not matter how to join it
upvoted 4 times
Hoeishetmogelijk
2 years, 5 months ago
Indeed it doesn't. Only an inner join shows more clearly the intention of the join.
upvoted 4 times
...
...
Hoeishetmogelijk
2 years, 5 months ago
It is the outer join that INCLUDES the records for which a foreign key is absent. It is the inner join that excludes records for which the foreign is absent. But this is exactly what you want, because only managers with a related Sales_Region must be included. So I agree with your answer but not with the reasoning ;-)
upvoted 5 times
...
...
hsetin
Most Recent 6 months, 2 weeks ago
sales_region and Region_manager has 1:1 relationship, so right join as provided in the answer will yield the same result.
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
1 - Merge RegionManager and Manager by using an inner join 2 - Merge SalesRegion and SalesManager by using an inner join 3 - Merge SalesRegion and RegionManager by using a right join as a new query named SalesRegionAndRegionManager
upvoted 1 times
...
agelee
9 months, 1 week ago
1,3,6 OR 3,1,6 BUT with assumption that we can loose managers from Sales_Manager by inner join to Sales_Region. I wonder that maybe option "2" should be taken instead of "3". Doing an inner join from smaller table (Sales_Region) wouldn't result in assigning random Sales Manager...? In fact max(Sales_Manager)
upvoted 1 times
...
Chellz
10 months, 2 weeks ago
After the exam, I left feedback to Microsoft saying this question is ambiguous and lacks practicality. "There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager." It means some managers are associated with region_id, but the region_id doesn't lead to a region name. Then it's ambiguous for the question to ask all managers that are associated with a region. In my opinion, step 2 takes care of all. Why 3 steps then? The question lacks practicality.
upvoted 2 times
...
JohnChung
1 year, 3 months ago
I think both 1-3-6 and 3-1-6 are correct. Be careful of the question "NOTE" - More than one order of answer choices is correct
upvoted 4 times
...
meer9673
1 year, 3 months ago
Why does it feel like a reading test?
upvoted 10 times
...
Dsbuff
1 year, 4 months ago
Either 1-3-6 or 3-1-6 is correct. Step 1 and 3 can be done separately. Step 6 is to merge the results of joins in Step 1 and 3 so Step 6 is the last step.
upvoted 1 times
...
og44
1 year, 5 months ago
Very confusing question. 2 out of 3 information is not used in the answers and comments. one-to-one relationship and the fact that some tables contain more records than others. Also, the given answer and the answer shared here are not the same.
upvoted 2 times
...
Kish07
1 year, 7 months ago
Either 1-3-6 or 3-1-6 or any other order is correct coz they clearly mentioned in the NOTE which is------ (NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select)
upvoted 2 times
...
poli361
1 year, 7 months ago
I think the options here are wrong cause we need left join to avoid losing some records from manager and sales manager table .
upvoted 3 times
...
Igetmyrole
1 year, 7 months ago
First Step: Merge [region_manager] and [manager] by using an inner join. Second Step: Merge [Sales_Manager] and [Sales_Region] by using an inner join. Third Step: Merge [Sales_Region] and [Sales_Manager] by using an inner join as a new query named [sales_region_and_manager]
upvoted 3 times
...
SinaRamzi
1 year, 8 months ago
I can understand the answers but does this sequence matter?
upvoted 1 times
bbshu0801
1 year, 4 months ago
Yes, the sequence does matter since it was mentioned in question "Which three actions should you perform in sequence?"
upvoted 1 times
...
...
JonDave
1 year, 10 months ago
this ones tough. gave me a headache just thinking about it
upvoted 5 times
...
Lavi29
1 year, 10 months ago
its 1,6,2 keeping the sales manager the last selection in inner join to be able to keep in the report. That is first 1- merge RM and M tables, then 6- merge SR and RM tables, then 2- merge SM and SR tables ( keeping the sales manager the last selection in inner join to be able to keep in the report.)
upvoted 1 times
...
Jwad
1 year, 10 months ago
I dont understnad why the order is 1, 3, 6. why cant i be the other orders like 6, 1, 3. please lmk bec i have exam in 2 days.
upvoted 1 times
...
Load full discussion...
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