Free Microsoft PL-300 Exam Dumps

Hotspot

You have a Power B1 model that contains a table named Date. The table has the following columns.

Answer is below.

Hotspot

You have a Power 31 data model that contains a table named Stores. The table has the following columns:

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:

Answer is as below

Hotspot

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.

Answer is as below.

DragDrop

You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

You add a sheer named Country to each page of the report.

You need to configure the report to meet the following requirements:

* When a user selects a country on the first page, the report must filter the other pages.

* The second and third pages must display only the filtered results.

Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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 model that contains a table named Date. The table has the following columns.

Hotspot

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

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

NOTE: Each correct selection is worth one point.

Box 1: CALCULATE

Hotspot

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are

a. NOTE: Each correct selection is worth one point.

)

Hotspot

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

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

NOTE: Each correct selection is worth one point.

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.