Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 14 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: You are designing a Power BI data model for a retail company to analyze sales performance. The dataset includes informat. Follow @CertPunch and visit certpunch.com for more certification practice exams and study content.
Prefer hands-on? Take this round as an interactive practice test — answer every question, get instant feedback, and see your score: Start the Microsoft Power BI Data Analyst Associate (PL-300) practice test →
What you will practice
- You are designing a Power BI data model for a retail company to analyze sales performance. The dataset includ…
- A Power BI Data Analyst needs to create a measure to calculate the percentage of late orders in a sales datas…
- You are importing an Excel file into Power BI Desktop. The Excel file contains multiple sheets, but you only…
- A Power BI Data Analyst is designing a report to show monthly sales trends over the past two years for a sing…
- A marketing team requests a Power BI report from you that analyzes historical campaign performance data. The…
- At Company A, the Environmental Analytics Team is analyzing CO₂ emissions data to identify patterns and facto…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. You are designing a Power BI data model for a retail company to analyze sales performance. The dataset includes information about transactions, products, customers, and store locations. Here's a simplified version of the data: Sales Data…
Answer: B. Sales Data, because it contains transactional details used for calculations and aggregations.
The Sales Data table is the fact table because it contains transactional metrics like Quantity and Total Sales used for aggregations. The other tables are dimensions, which provide descriptive context for filtering and grouping the numerical facts.
Q2. A Power BI Data Analyst needs to create a measure to calculate the percentage of late orders in a sales dataset. The Sales table includes columns for OrderID, ShipDate, and ExpectedShipDate. An order is considered late if ShipDate is after…
Answer: C. LateOrderPct = DIVIDE(COUNTROWS(FILTER(Sales, Sales[ShipDate] > Sales[ExpectedShipDate])), COUNTROWS(Sales), 0)
The correct DAX expression filters the table for late orders, counts those rows, and safely divides by the total row count. Options using basic division without DIVIDE risk errors from zero denominators, and CALCULATE cannot directly accept a boolean filter expression like this.
Q3. You are importing an Excel file into Power BI Desktop. The Excel file contains multiple sheets, but you only need to load data from a specific sheet named "SalesData". What is the most efficient approach to load only the required data?
Answer: D. Use the Excel Workbook connector and select the "SalesData" sheet.
Using the Excel Workbook connector opens the Navigator window, letting you select exactly which sheet to load. The Folder and Web connectors are for different data sources, while importing the entire workbook wastes system resources and requires unnecessary transformations.
Q4. A Power BI Data Analyst is designing a report to show monthly sales trends over the past two years for a single product category. The dataset includes a Sales table with SaleDate and SalesAmount columns, related to a Date table. The analys…
Answer: A. A line chart with SaleDate (Month) on the x-axis and SalesAmount on the y-axis.
A line chart is the standard visual for displaying continuous data trends over time, effectively highlighting patterns and changes across months. Bar and pie charts are better for categorical comparisons, while tables lack immediate visual trend clarity.
Q5. A marketing team requests a Power BI report from you that analyzes historical campaign performance data. The dataset is relatively static, with updates happening only once a month. They prioritize fast report performance and the ability to…
Answer: C. Import mode, because it allows for faster report performance and complex data modeling.
Import mode copies the data into memory, providing the fastest report rendering and allowing complex DAX calculations and relationships. DirectQuery is reserved for near real-time needs, whereas Import mode relies on scheduled refreshes rather than providing live insights.
Q6. At Company A, the Environmental Analytics Team is analyzing CO₂ emissions data to identify patterns and factors contributing to high emission levels. They are using the Key Influencers visual in Power BI to determine both general influence…
Answer: A. Top Segments
Switching to the Top Segments tab groups the data into clusters that share similar characteristics and display the target metric prominently. The primary Key Influencers tab isolates individual factors that drive the metric higher or lower, rather than grouping data points.
Q7. You are creating a Power BI report that retrieves data from an Azure SQL database. You need to ensure that the report reflects real-time data updates without manually refreshing the dataset. What should you do?
Answer: C. Set the storage mode to DirectQuery for the dataset
Setting the storage mode to DirectQuery sends queries to the underlying Azure SQL database in real time, fetching the most current data upon interaction. Import mode and scheduled refreshes rely on cached data, meaning users might see outdated information.
Q8. You are tasked with creating a Power BI report to visualize project data from a project management app hosted in Microsoft Teams. The app provides data through Microsoft Dataverse. What steps should you follow to connect to this data and b…
Answer: C. Install the Power BI app in Teams and create a new report using the Dataverse connector
Installing the Power BI app within Microsoft Teams and utilizing the native Dataverse connector provides direct, seamless access to the project data. Exporting to CSV or relying on SharePoint connectors creates unnecessary friction and bypasses the built-in integration features.
Q9. You are a Power BI developer managing the Adventure Works Pipeline, which includes Development, Test, and Production environments. You create new reports and dashboards in the Development workspace, tests them in the Test environment, and…
Answer: B. To streamline the deployment of datasets, reports, and dashboards across Development, Test, and Production environments.
Deployment pipelines streamline moving datasets, reports, and dashboards across development, test, and production stages. This managed lifecycle ensures content is thoroughly validated before reaching business users, whereas other options describe unrelated administrative tasks.
Q10. A Power BI Data Analyst is building a report to show the percentage contribution of each product's sales to the total sales. The dataset includes a Sales table with Product and SalesAmount columns. The analyst wants to use Power BI's Quick…
Answer: D. Select "Percentage of grand total" for SalesAmount with Product as the base field.
The percentage of grand total quick measure divides each product's sales by the overall total sales amount. This efficiently calculates the requested contribution without writing manual DAX, unlike rolling averages or running totals which track cumulative time data.
Q11. A Power BI Data Analyst at a healthcare organization needs to create a visual showing the relationship between patient recovery time (in days) and patient satisfaction scores (%). The visual should help identify patterns and highlight unus…
Answer: A. Scatter chart
A scatter chart plots two numerical values against each other, making it ideal for identifying correlations and outliers. Pie charts and tables fail to highlight unusual combinations effectively, such as short recovery times paired with low satisfaction scores.
Q12. You are building a Power BI report for EcoMetrics Solutions, and you need to create a new query to apply additional transformations to the existing Sales query. You want to ensure that if the original Sales query is updated, the new query…
Answer: A. Create a reference of the Sales query.
Creating a reference outputs a new query linked to the original, so upstream changes flow downstream automatically. Duplicating creates a disconnected static copy, meaning any future updates to the original query will not be inherited.
Q13. You are creating a Power BI report to help the Operations team analyze the monthly production output across five different factories over the past three years. The team wants to: Compare production trends over time for each factory. Easily…
Answer: B. Line Chart with Multiple Lines
A line chart with multiple lines easily compares continuous trends across several categories side-by-side over time. Bar charts are better for independent snapshots, while pie charts obscure continuous historical patterns across multiple factories.
Q14. A Power BI Data Analyst has published a report to the Power BI Service with a dataset containing sales data by region. The analyst needs to ensure that each regional manager only sees data for their own region when viewing the report. The…
Answer: C. Configure row-level security (RLS) in Power BI Desktop by defining roles based on the Region column.
Configuring row-level security filters data at the database level, restricting regional managers from viewing unauthorized records. Unlike visual filters or slicers, RLS cannot be easily bypassed by users in the service, providing true dynamic data governance based on the logged-in user.
More Microsoft Power BI Data Analyst Associate (PL-300) drills and other practice exams are on @CertPunch. New rounds drop every few days at certpunch.com.