Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

* Use Analytics views.

* Filter data from the cloud.

Which connector should you use?

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

You have a Power B1 report that contains the visuals shown in the following table.

You need to modify the location of each visual.

What should you modify for each visual?

You have a Power Bl model that contains two tables named Population and Date.

The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power Bl model contains two measures that have the following definitions.

Total Population = Sum ('Population'[Population Amount])

2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)

You create a table visual that displays Date[Year] and [2023 Population].

What will the table visual show?

You have a Power Bl model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

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?

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.