V2 PL-300 F (62 Q ) 102:200

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

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.

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?

• Enable visual interactions.

• Change any DAX measures to use iterator functions.

• Implement row-level security (RLS).

• Remove unused columns from tables in the data model.

You have a Power BI data model that contains a table named Employees. The table has the following columns:

•Employee Name

•Email Address

•Start Date

•Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

•Users must see only their own employee data.

•The DAX expression must work in both Power BI Desktop and the Power BI service.

Which expression should you use?

• [Email Address] - USERNAME()

• [Employee Name] - USERPRINCIPALNAME()

• [Employee Name] = USERNAME()

• [Email Address] = USERPRINCIPALNAME()

You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.

You use Power Query to load a query that contains both renamed and custom columns.

Later, you attempt to reload the query and receive the following error message.

Expression.Error: The column 'Category' of the table wasn't found.

What are two possible causes of the error?

• The column was removed from the source file.

• The column was renamed in the source file.

• The file is no longer in the specified location.

• The data type of the column was changed.

ou have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

•Order Line ID

•Product ID

•Unit Price

•Order ID

•Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an

order contains a different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

• Count('Sales'[Order ID])

• CountA('Sales' [Order ID])

• CountRows('Sales')

• DistinctCount('Sales' [Order ID])

you have a Power BI model that contains a table named Date. The Date table contains the following columns:

•Date

•Fiscal Year

•Fiscal Quarter

•Month Name

•Calendar Year

•Week Number

•Month Number

•Calendar Quarter

You need to create a calculated table based on the Date table. The calculated table must contain only unique

combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.

Which DAX function should you include in the table definition?

• ADDCOLUMNS

• CALCULATE

• SUMMARIZE

• DATATABLE

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel

file as shown in the following exhibit.

You need to shape the query to display the following three columns:

•Month

•Sales

•Year

What should you select in Power Query Editor?

• Merge columns

• Transpose

• Unpivot columns

• Pivot column

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source.

The sales table has the following date foreign keys:

•Due Date

•Order Date

•Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order

Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date

table.

Does this meet the goal?

• Yes

• No

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected

period.

Which DAX calculation should you use?

• CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )

• CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )

• TOTALQTD ( [Total Sales], Date[Date] )

• CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )