QUESTION: 109

You have a Power BI model that contains a table named Employee. The table contains the following data.
Each employee has one manager as shown in the ParentEmployeeID column.
All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
Which DAX expression should you use?

PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))
PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)
PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)
PATH(Employee[EmployeeID],Employee[ParentEmployeeID])

Answer(s): A

Reveal Solution Next Question

QUESTION: 110

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

Replace the default visuals with AppSource visuals.
Remove unused columns from tables in the data model.
Change the imported dataset to DirectQuery
Increase the number of times that the dataset is refreshed.

Answer(s): B

Reveal Solution Next Question

QUESTION: 111

You use Power Query Editor to preview a query that contains sales order data in the following columns:
• Tax Amount
• Sales Order ID
• Freight Amount
• Subtotal Amount
• Total Item Quantity
The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount.
You need to query the data to identify the following metrics by month:
• The average item quantity per order
• The average freight amount per order
• The maximum item quantity per order
How should you modify the query?

In the Total Item Quantity column, replace the null values with 0.
In the Tax Amount column, remove rows that contain null values.
In the Freight Amount column, remove rows that contain null values.
In the Freight Amount column, replace the null values with 0.

Answer(s): D

Reveal Solution Next Question

QUESTION: 112

HOTSPOT (Drag and Drop is not supported)
You have the Power BI data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.