Microsoft PL-300 Practice Test - Questions Answers, Page 41

You are creating a Power Bi report that will contain multiple visuals. Vou need to ensure that the report Is accessible to users who use a screen reader. Which two configurations should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a semantic model that contains a table named Sales. The table contains the following columns;

* Order ID

* Product ID

* Sales Dote

* Sales Amount

You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a semantic model named Model1 that contains the following tables

There is an active relationship between SaleDate and Date.

There is an inactive relationship between ShippingDate and Date-

You need to create a new measure that will display the total amount of sales and support slicing by ShippingDate.

HOTSPOT

Vou have a Power B1 semantic model that contains the following table named Employees.

An employee is considered active if the TermDate column for that employee contains no value.

You need to create a DAX measure that will count the number of active employees.

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.

DRAG DROP

You have a Power B1 semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.

The model contains one measure that has the following formula.

Deliveries = COUNTROWS('fact Deliveries')

Vow have a Power 81 semantic model named Modell that runs in Import storage mode. Vou need to reduce the size of Model 1. The solution must NOT increase report query response times. What should you do?

You plan to generate a line chart to visualize and compare the last six You need to Increase the accessibility of the visual. What should you do? O A-

You use Power B1 Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.

File1 Is moved to a different folder.

When you open RPT1 in Power B1 Desktop, you discover that the report displays outdated data.

You need to ensure that the data in File1 refreshes properly.

What should you do?

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You decrease the dashboard cache update frequency.

Does this meet the goat?