PL-300 Exam - Question 44

Question

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:.

Examice · Accepted 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/

Nurgul · Answer

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.

sylesh · Answer

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.

phantomghost · Answer

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

meer9673 · Answer

Why does it feel like a reading test?

rainy_255 · Answer

This was in the exam this week.

sdaaram · Answer

This was on exam yesterday

AKUMAR2104 · Answer

This was on Exam Today

Igetmyrole · Answer

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]

JohnChung · Answer

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

Tareqk · Answer

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

poli361 · Answer

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

Kish07 · Answer

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)

og44 · Answer

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.

Chellz · Answer

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.

SinaRamzi · Answer

I can understand the answers but does this sequence matter?

Dsbuff · Answer

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.

agelee · Answer

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)

PL-300 Exam - Question 44

Discussion