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

You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?

DRAG DROP

You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power Bl report.

You need to prepare the data so that it is available to the model in the format shown in the following table.

Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have a Power Bl report that contains a page. The page contains the following:

• A shape named Shape 1

• A card named Sales Summary

• A clustered bar chart named Sales by Region

You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

DRAG DROP

You use Power Query Editor to preview customer feedback data.

You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

• What the customers most often provide feedback about

• Whether the customers like your company’s product

• The language of the feedback

Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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.

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

HOTSPOT

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.

DRAG DROP

You have a Power Bi report that contains five bookmarks.

You need to add an object to the report from which users can navigate between three specific bookmarks.

How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.

NOTE: Each correct selection is worth one point.

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.

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?