Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 6

Questions 51

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Options:
A.

bar chart

B.

scatterplot

C.

pie chart

Microsoft PL-300 Premium Access
Questions 52

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Options:
A.

Merge queries

B.

Append queries

C.

Combine files

Questions 53

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Options:
A.

Change lite OrderlD column in the Orders table to the text data type.

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

Questions 54

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

PL-300 Question 54

Options:
Questions 55

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

PL-300 Question 55

Options:
Questions 56

You need to create the dataset. Which dataset mode should you use?

Options:
A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

Exam Code: PL-300
Certification Provider: Microsoft
Exam Name: Microsoft Power BI Data Analyst
Last Update: Jul 10, 2025
Questions: 434