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

You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure:

You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

You have a Power B1 report that contains one visual

You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

You have a Power Bl report that contains a table visual The visual contains a column.

The column contains whole numbers ranging from o* 1 to 20.

You need to use conditional formatting to meet the following requirements:

* Visually compare the values without having to read the text containing the number.

* Show a different format for each distinct value

* Hide the numeric value of ColumnA.

* Minimize development effort.

Which formatting should you use?

HOTSPOT

You attempt to use power Query Editor to create a custom column and receive the error message 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.

HOTSPOT

You have a semantic model that has the permissions shown in the following exhibit.

Use the drop-down menus to select the answer choice the that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have a Microsoft 365 subscription that contains the resources shown in the following table.

You create a new dashboard that uses row-level security (RIS) filters You define a new role named Consultants.

To which resource can you assign the Consultants role?

You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

HOTSPOT

You hove a folder that contains 50 JSON files.

You need to use Power 81 Desktop to make the metadata ol the files available as a single semantic model. The solution must NOT store the data of the JSON files.

Which type of data source should you use. and which transformation should you perform? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power B1 semantic model named Model 1 that runs in import storage node.

You need to reduce the size of Model.

Which two action should you perform? Each connect answer presents a complete solution.

NOTE: Each correct selection is worth one point.