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

Page: 1 / 14
Total 342 questions
Question 1

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?

Answer : D

Question 2

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?

Answer : C

Question 3

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?

Answer : C

Question 4

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.

Answer : B, D

Question 5

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 tab*e 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?

Answer : C

Question 6

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

Answer : A

Question 7

What is the minimum number of Power BI datasets needed to support the reports?

Answer : A

Page:    1 / 14   
Total 342 questions