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

HOTSPOT

You have a Power BI model that has the following tables:

Product (Product_id, Product_Name)

Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID])

You need to create the following relationships:

Sales to Product

Sales to Salesperson

The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson. How should you configure the relationships? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT

You have a report in Power BI Desktop as 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.

DRAG DROP

You have a Power BI model that contains a table named Sales. Sales has the following three measures:

A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million. A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million. A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] – Sales[This Year]. You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value 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 are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.

You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name. You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published. How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT

You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

You need to add a new column that contains the data in the format of nnn-nnn-nnnn.

How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:

• Only show single-value visuals.

• Minimize scrolling.

What should you do?

You have a Power Bl report

You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:

• A card that shows the number of records

• A bar chart that snows total transaction amount by territory

• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?

You are creating a line chart in a Power Bl report as 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 Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled. No anomalies ate detected

You need to increase the likelihood that anomaly detection will identify anomalies in the report.

What should you do?