Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You have a query in Power Query Editor that contains the following data.

You need to transform the data to appear as shown in the following table.

What should you do?

AConvert the Classes column into a list.

BUnpivot the Classes column.

CExtract the text between delimiters in the Classes column.

DSplit the Classes column into rows by using a delimiter.

Answer : D

Question 2

In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

What should you do?

AModify the members of the app workspace.

BConfigure security for the dataset used by the app.

CShare the dashboard, and then modify the Access settings of the dashboard.

DFrom the app workspace, click Update app, and then configure the Access settings.

Answer : C

Question 3

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

AFrom Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

BFrom Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

CFrom Power Bl Desktop, use the Auto date/time option when creating the reports.

DFrom Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Answer : B

Use Power Query to calculate calendar quarter and calendar month.

Scenario:

A single dataset must support all three reports:

- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.

The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

Question 4

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

You need to reduce the load times of the query without affecting the analysis.

Which two actions achieve this goal? Each correct answer presents a complete solution.

NOTL Each correct selection is worth one pant.

ARemove the rows in which sales [status] has a value of Canceled.

BChange the data type of sale [Delivery_Time] to Integer

CRemoves (Canceled Date).

DSplit Sales [Sale_Date] into separate date and time columns.

ERemove sales [Sales_Date].

Answer : A, D

Question 5

You have a Power Bl report that contains a table visual The visual contains a column.

The column contains whole numbers ranging from o* 1 to 20.

You need to use conditional formatting to meet the following requirements:

* Visually compare the values without having to read the text containing the number.

* Show a different format for each distinct value

* Hide the numeric value of ColumnA.

* Minimize development effort.

Which formatting should you use?

Abackground color

Bfont color

Cicons

Ddata bars

Answer : D

Question 6

SIMULATION

You need to create a measure that will return the percentage of late orders.

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

NOTE: Each correct selection is worth one point.

ASee the answer as below in explanation

Answer : A

Answer as below

Question 7

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

Adecomposition tree

BQ&A

Csmart narrative

Dkey influences

Answer : D

Microsoft Power BI Data Analyst PL-300 Exam Practice Test