- (Exam Topic 4)
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.
Solution:
* 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.
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?
Correct Answer:
D
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
Column quality Column distribution Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/
- (Exam Topic 4)
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
A line chart that shows the number of defective products manufactured by day. A KPI visual that shows the current daily percentage of defective products manufactured. You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create?
Correct Answer:
D
- (Exam Topic 4)
You have the data lineage 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.
Solution:
Text, table Description automatically generated with medium confidence
Box 1: CONTOSO BIKES report Box 2: three datasets
Images, tweets and the Contoso datasets.
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
You are modifying a Power Bi model by using Power Bl Desktop. You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Solution:
FILTER | AND | CALCULATE
Does this meet the goal?
Correct Answer:
A
