Free Microsoft PL-300 Exam Questions

Become Microsoft Certified with updated PL-300 exam questions and correct answers

Page: 1 / 93

Total 465 Questions | Updated On: Mar 20, 2026

Add To Cart

Question 1

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?

A : Add a Top N filter to the visual.

B : Configure the Sales Profit measure to use the RANKX function.

C : Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column

D : Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

Answer: A

Question 2

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

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

B : From Power Bi Desktop, use the Auto date/time option when creating the reports.

C : From 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.

D : From 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

Answer: B

Question 3

You have a table named DiMCountries that contains a column named Country as shown in the following table.You plan to use DiMCountnes as a dimension m a report. You new to ensure that the Country column in DiMCountnes lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

A : Replace the empty fields.

B : Apply a clean transform.

C : Remove duplicate values.

D : Change Data category to Country.

E : Apply a Capitalize Each Word transform.

Answer: B,C

Question 4

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?

A : From Power Query Editor, split the Machine-User column by using a delimiter.

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

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

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

Answer: A

Question 5

You have a Power Bi report for the procurement department. The report contains data from the following tables

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

A : Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

B : Merge Suppliers and Uneltems.

C : Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

D : Remove the Lineitems[Description] column.

Answer: D

Page: 1 / 93

Total 465 Questions | Updated On: Mar 20, 2026

Add To Cart