Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 3

You have a Power Bl semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model.

You have a Power BI data model 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: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You have a Power BI imported dataset that contains the data model 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.

You have a dataset named Pens that contains the following columns:

Item

Unit Price

Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are creating a Power Bi model in Power BI Desktop

You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.

You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:

• The percentage of values that contain errors.

• The count of empty values.

What should you enable? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

A user creates a Power B1 report named ReportA that uses a custom theme

You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.