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…

QuestionsCategory: PL-300DRAG 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…
Admin Staff asked 4 months ago
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.
 Image
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:
 Image
















 

Suggested Answer: 
    Correct Answer Image

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/

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.