This is the free Microsoft PL-300 practice question bank —
190 of 369 total questions, each with a full explanation, free to
read with no signup required. Updated 2026-08-05.
Every answer is verified against official Microsoft documentation —
see our methodology.
Question 1
You have the dashboard shown in the following exhibit.
You need to modify the dashboard to display as shown in the following exhibit.
What should you do?
A. Create and apply a custom dashboard theme.
B. Change the colors of the visuals in the report.
C. Apply the Dark dashboard theme.
D. Upload a snapshot image of the dashboard.
Show Answer
Correct Answer: A
Explanation: The required changes are most consistent with applying a custom dashboard theme. Dashboard themes control the dashboard appearance (such as tile/background colors), and pinned visuals on a dashboard cannot have their colors edited directly from the dashboard after pinning. Changing report visual colors would not comprehensively restyle the dashboard, the built-in Dark theme is limited to the predefined theme, and a snapshot image would remove interactivity.
Question 1
You have a Power BI report named Report1.
You add a bookmark to Report1 and use the default bookmark options.
Which element is saved in the bookmark?
A. default summarization
B. data sources
C. Report settings
D. filters
Show Answer
Correct Answer: D
Explanation: With the default bookmark options, Power BI bookmarks save the current state of the report, including filters, slicers, visual display state, sort order, and drill location. They do not save data sources, report settings, or default summarization.
Question 2
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Replace the default visuals with AppSource visuals.
B. Remove unused columns from tables in the data model.
C. Change the imported dataset to DirectQuery
D. Increase the number of times that the dataset is refreshed.
Show Answer
Correct Answer: B
Explanation: Removing unused columns reduces the imported model size and memory footprint, improving compression and query performance, which helps report visual load times. Import mode is generally faster than DirectQuery for interactive reports of this size, replacing default visuals with AppSource visuals would not improve performance, and increasing refresh frequency does not affect report rendering speed.
Question 2
You have a Power BI report.
You plan to use the Analyze feature to explain unusual distributions in visuals.
You need to identify insights in the data.
What should you do?
A. Right-click a data point on a visual, and then select Analyze.
B. Select the visual, and then select Get insights in the action bar.
C. Create a scatter chart, and then add a trend line to the chart.
D. Create a forecast by using the Analytics pane.
Show Answer
Correct Answer: A
Explanation: The Analyze feature in Power BI is accessed by right-clicking a data point in a supported visual and selecting Analyze (for example, Explain the increase/decrease or Find where this distribution is different) to identify insights and explain unusual distributions. The other options refer to different analytics capabilities such as Quick Insights, trend lines, or forecasting, not the Analyze context-menu feature.
Question 3
DRAG DROP
-
You receive annual sales data that must be included in Power BI reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year
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.
Show Answer
Correct Answer: 1. Select the Month and MonthNumber columns.
2. Select Unpivot other columns.
3. Rename the Attribute column as Year and the Value column as Sales.
Explanation: Keep Month and MonthNumber fixed, unpivot the year columns into Attribute/Value pairs, then rename them to Year and Sales for proper time-based reporting and slicers.
Question 3
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You are creating a Power BI semantic model named Model1 that contains the following tables.
The tables have the following relationships.
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the Salesperson table.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: A
Explanation: Yes. If the Salesperson table contains only the SalespersonID key and no additional attributes, it is redundant because the Sales table already contains SalespersonID. Removing the redundant dimension slightly reduces model size while still allowing analysis of total sales by salesperson (using SalespersonID from Sales) and by city through the existing relationships. The required analysis remains possible.
Question 4
You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table.
Which type of visualization should you use?
A. area chart
B. scatter plot
C. pie chart
D. donut chart
Show Answer
Correct Answer: B
Explanation: A scatter plot is the standard visualization for identifying outliers because it displays individual data points, making values that fall far from the overall pattern easy to spot. Area, pie, and donut charts summarize data and are not suitable for detecting outliers.
Question 4
You have a Power BI model that contains several tables. Each table contains multiple columns.
You discover that some columns are redundant and are NOT required for reporting.
You need to remove the redundant columns. The solution must meet the following requirements:
• Ensure that the model remains usable for reporting.
• Minimize administrative effort.
What should you do?
A. From the Data pane, select the redundant columns, and then select Delete from model.
B. From the Model pane, right-click the tables that contain the redundant columns, and then select Hide in report view.
C. From Power Query Editor, remove the redundant columns.
D. From the Data pane, select the redundant columns, and then select Hide in report view.
Show Answer
Correct Answer: C
Explanation: Removing redundant columns in Power Query Editor prevents them from being loaded into the model, reducing model size and improving efficiency while keeping the model usable for reporting with only required fields. Hiding columns only affects visibility; the redundant columns remain in the semantic model. Deleting columns directly from the model can have similar effects but managing schema at the query stage minimizes ongoing administrative effort and keeps the model definition clean.
Question 5
You have a Power BI report.
You have a table named Data1 that contains 10 million rows.
Data1 is used in the following visuals:
✑ A card that shows the number of records
✑ A bar chart that shows total transaction amount by territory
✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory
You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.
What should you do?
A. Add a count field of the transaction amount to the size bucket of the scatter plot.
B. Add a trend line to the scatter plot.
C. Enable high-density sampling on the scatter plot.
D. Apply a row filter to the Data1 query in Power Query Editor.
Show Answer
Correct Answer: C
Explanation: Enable high-density sampling on the scatter plot. With 10 million rows, a standard scatter plot can suffer from overplotting and poor responsiveness. High-density sampling is designed specifically for large datasets to preserve the visual distribution and reveal meaningful patterns while improving rendering. It only affects how the scatter plot is rendered and does not change the underlying data or the accuracy of the card or bar chart. Adding a trend line helps indicate a relationship but does not address the visualization challenges caused by millions of points; adding a size field changes the encoding; filtering rows in Power Query would alter the dataset and affect the other visuals.
Question 5
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You are creating a Power BI semantic model named Model1 that contains the following tables.
The tables have the following relationships.
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You summarize the data in the Sales table by SalesPersonID.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: Summarizing the Sales table only by SalesPersonID removes the city-level granularity. The requirement is to analyze total sales by salesperson per city, which requires retaining both SalesPersonID and CityID (or equivalent city grain). Therefore, this solution does not meet the goal.
$19
Get all 369 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
