Free Microsoft PL-300 Exam Dumps

Hotspot

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

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.

MultipleChoice

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

Hotspot

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

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are

a.

Answer is as below:

OrderList

You build a report about warehouse inventory dat

a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

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

MultipleChoice

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

* Create reports that use the HR dataset.

* Publish the reports to WorkspaceB.

* Prevent the ability to modify the HR dataset.

* Prevent the ability to add users to WorkspaceB.

MultipleChoice

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

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are

a.

OrderList

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

DragDrop

You are modifying a Power Bi model by using Power Bl Desktop.

You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

Hotspot

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

:

MultipleChoice

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged

contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

D18912E1457D5D1DDCBD40AB3BF70D5D

What should you do?