Microsoft PL-300 Exam Practice Test Instant Access

Question 1

In Power BI Desktop, you have a dataset that contains a table.

You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.

What should you do?

ASet the Data category of the Plant Image field to Image URL

BSet the Data type of the Plant Image field to Binary.

CSet the Data category of the Plant Image field to Web URL.

DFrom the Formatting tab. select Values, and then set URL icons to On for the table.

Answer : A

Question 2

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

* If the discount column returns an error, a discount of 0.05 must be used.

* All the rows of data must be maintained.

* Administrative effort must be minimized.

What should you do in Power Query Editor?

ASelect Keep Errors

BEdit the query in the Query Errors group.

CSelect Replace Errors

DSelect Remove Errors.

Answer : C

Question 3

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?

ADATATABLE

BADDCOLUMS

CSUMMARIZE

DCALCULATE

Answer : C

Question 4

You have a Power Bl report that contains a page. The page contains the following:

* A shape named Shape 1

* A card named Sales Summary

* A clustered bar chart named Sales by Region

You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

ATab order in the Selection pane

BLayer order in the Selection pane

CMaintain layer order in the General visual settings

DVertical alignment in the Canvas settings

Answer : B

You use Power Query Editor to preview the data shown in the following exhibit.

You confirm that the data will always start on row 3, and row 3 will always contain the column names.

You use Power Query Editor to preview the data shown in the following exhibit.

Question 5

You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?

AFrom Power Query Editor, split the Machine-User column by using a delimiter.

BIn a DAX function, create two calculated columns named Machine and User by using the substitute function.

CFrom Power Query Editor, create a column that contains the last three digits of the Machine-User column.

Din a DAX function, create two measures named Machine and User by using the substitute function.

Answer : A

Question 6

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

Aa single imported dataset

Btwo imported datasets

Ctwo DirectQuery datasets

Da single DirectQuery dataset

Answer : A

Question 7

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

AOption A

BOption B

COption C

DOption D

Answer : A, D

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