Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

You have a data source that contain a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required types.

Does this meet the goal?

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?

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 create a Power Bl report1 named Summary1 You discover that Summary1 is slow.

You run Performance analyzer to identify performance metrics for Summary1

Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

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?

You have a Rawer Bl report That imports a dace 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?

You have a Power B1 report named ReportA.

You have a Power B1 tenant that allows users to export data.

You need to ensure that consumers of ReportA cannot effort any data from visuals.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE Each correct selection is worth one point.