Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 44

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:

    Correct Answer:

    Step 1: Merge [Sales_Region] and [Sales_Manager] by using an inner join.

    Inner Join: Returns the rows present in both Left and right table only if there is a match. Otherwise, it returns zero records.

    Note: Sales_Region and Sales_manager

    There is a one-to-one relationship between Sales_Region and Region_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.

    Step 2: Merge [Region_Manager] and [Manager] by using inner join.

    Only managers who are associated to a sales region must be included in the reports.

    Note: Region_Manager and Manager.

    There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.

    Step 3: Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager]

    Reference:

    https://www.tutorialgateway.org/joins-in-power-bi/

Discussion
Nurgul

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.

md_sultan

I just have a query if we have selected first 6 ,3,1 then am I going to get less points here?

Allen879385

me too

TestPB

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

md_sultan

TestBP, can you plz elaborate , i am not able to understand how 2 table and 1 table will be created

Nemesizz

Why two tables? I dont get it

semauni

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.

semauni

So I think 1-3-6 is an option, 3-1-6 as well, but starting with 6 is not.

GabryPL

Ok but what about 3,1,6. It will be the same

Time2excel

you are an absolute genius!

FinelogBiseum

Approved

sylesh

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.

RickyAnd

exactly, I agree

NevilleV

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.

lukelin08

What did you decide was the correct answer?

Lewiasskick

The sales Region and Region manager has one to one relationship, therefore, it does not matter how to join it

Hoeishetmogelijk

Indeed it doesn't. Only an inner join shows more clearly the intention of the join.

Hoeishetmogelijk

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 ;-)

phantomghost

I hope this question is not on the test, its scary

meer9673

Why does it feel like a reading test?

rainy_255

This was in the exam this week.

AKUMAR2104

This was on Exam Today

sdaaram

This was on exam yesterday

Tareqk

This is was on the exam today. 2024-04-19

JohnChung

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

Igetmyrole

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]

Chellz

Was on June 8, 2024 exam. Didn't like it :( 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.

og44

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.

Kish07

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)

poli361

I think the options here are wrong cause we need left join to avoid losing some records from manager and sales manager table .

agelee

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)

Dsbuff

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.

SinaRamzi

I can understand the answers but does this sequence matter?

bbshu0801

Yes, the sequence does matter since it was mentioned in question "Which three actions should you perform in sequence?"