[Aug 01, 2026] Download Free Microsoft PL-300 Real Exam Questions [Q240-Q257]

Q240. You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q241. You have a Power BI model that contains a table named Sales. Sales has the following three measures:
* A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
* A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
* A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] – Sales[This Year].
You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Q242. You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q243. You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

Q244. You use Power Query Editor to preview customer feedback data.
You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
* What the customers most often provide feedback about
* Whether the customers like your company’s product
* The language of the feedback
Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service may be used once, more than once. or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Q245. You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.

Q246. You have a Power Bl report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. 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.

Q247. 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?

Q248. You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

Q249. You open powerbi.com as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Q250. You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

Q251. 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?

Q252. You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Q253. You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Q254. You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.

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

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
Which three actions should you perform in sequence? To answer move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Q256. You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q257. You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
* Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.
* Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.