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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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 configure incremental refresh.

Does this meet the goal?

HOTSPOT

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 are a. NOTE: Each correct selection is worth one point.

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.

You need to create a report that will contain the visual shown in the following exhibit.

The solution must NOT require additional DAX measures.

Which type of visual should you use?

You have a Power B1 report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader. What should you configure on the bar chart?

You create a Power B1 report named RPT1 that contains sales data. The data contains 10 million rows. RPT1 contains 15 different visuals.

Users state that RPT1 is slow to load.

You need to investigate the cause of the issue.

What should you use?

HOTSPOT

You have a Power B1 semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.

You need to create a calculated table that will cover the range of dates in both tables.

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.

You have a Fabric tenant that hosts the semantic models shown in the following table.

The auto date/time option or the model is enabled.

You need to reduce the size of the model while maintaining the ability to analyze product sales by month and quarter.

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

NOTE: Each correct answer is worth one pent.

DRAG DROP

You a-e using Power Bl Desktop 10 profile data in Power Query Editor.

You need to review the percentage of errors and the maximum value of each column.

Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Power B1 semantic model.

You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.

How should you complete the OAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.