Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 15 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: A Power BI Data Analyst has published a sales dataset to the Power BI service with row-level security (RLS) configured. . 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
- A Power BI Data Analyst has published a sales dataset to the Power BI service with row-level security (RLS) c…
- BrightMart has historical sales data dating back 10 years, but reports only need the last 2 years for perform…
- You are managing permissions for a shared dataset. Amelia, a Workspace Admin, wants to grant a third-party co…
- At DataLens Analytics, you notice that your report page takes a long time to load. You decide to use the Perf…
- A Power BI Data Analyst needs to create a sales report using data from two sources: sales transactions stored…
- You are a data analyst at GlobalTrade Corp., tasked with creating a Power BI report that allows users to dyna…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. A Power BI Data Analyst has published a sales dataset to the Power BI service with row-level security (RLS) configured. A manager wants to analyze the data in Excel using a PivotTable, and the analyst needs to ensure the manager only sees…
Answer: C. Instruct the manager to use "Analyze in Excel" from the Power BI service, which will automatically apply RLS
Analyze in Excel connects directly to the published Power BI dataset, so the established row-level security filters automatically apply to the PivotTable. Granting admin permissions or exporting raw data bypasses security and poses a significant data governance risk.
Q2. BrightMart has historical sales data dating back 10 years, but reports only need the last 2 years for performance reasons. What is the best way to optimize the dataset?
Answer: D. Apply a Power Query filter to remove old data before loading it into Power BI.
Filtering the date column in Power Query removes unnecessary rows before they ever load into the memory model, drastically reducing dataset size and improving performance. A DAX filter only hides the old data at runtime, leaving the unused data still loaded in memory.
Q3. You are managing permissions for a shared dataset. Amelia, a Workspace Admin, wants to grant a third-party contractor temporary access to build reports on the dataset. What steps should she take to achieve this?
Answer: C. Grant the contractor Direct Access with Build permission for the dataset.
Granting Build permission via Direct Access allows the contractor to connect to the dataset and author new reports without elevating their workspace rights. Adding the user directly to the workspace as a Member or Admin gives excessive control and poses a security risk.
Q4. At DataLens Analytics, you notice that your report page takes a long time to load. You decide to use the Performance Analyzer tool to identify the visual causing the delay. After running the Performance Analyzer, one of your visuals shows…
Answer: C. The visual contains a complex DAX measure that is slowing down the query.
A high duration in the DAX Query category means the engine is taking a long time to evaluate the measure for that visual. Formatting and network latency appear elsewhere in the analyzer, so focus on tuning the DAX.
Q5. A Power BI Data Analyst needs to create a sales report using data from two sources: sales transactions stored in a SQL Server database and product information in an Excel file stored on OneDrive for Business. What should the analyst do to…
Answer: B. Use the SQL Server connector for the database and the Excel connector for the OneDrive file
Power BI Desktop supports multiple data sources in a single model, so using the native SQL Server and Excel connectors is the correct approach. Manual exports or the generic web connector lose native functionality and can break scheduled refreshes.
Q6. You are a data analyst at GlobalTrade Corp., tasked with creating a Power BI report that allows users to dynamically filter sales data based on a specific region. The list of regions (e.g., North, South, East, West) should be selectable fr…
Answer: A. Use a slicer visual connected to the Regions column.
A slicer visual connected to the Regions column provides the required interactive dropdown experience. Row-level security is for securing data per user, while calculated columns are static and lack the interactivity users need.
Q7. At EcoMetrics Corp., you are tasked with creating a measure that calculates the total sales for the "Electronics" product category. The Sales table is linked to the Products table, which contains: ProductID Category The Sales table contain…
Answer: B. Total Electronics Sales = CALCULATE(SUM(Sales[SalesAmount]), Products[Category] = "Electronics")
Using CALCULATE with a filter on the Products table correctly evaluates the total sales for the Electronics category across the existing relationship. The FILTER function requires an iterator like SUMX to work properly over the related Sales table.
Q8. A Power BI Data Analyst needs to create a visualization to show the relationship between Unit Price and Quantity Ordered for a retail dataset. The goal is to help stakeholders understand how these two variables interact across individual s…
Answer: C. Create a scatter chart with Unit Price on the x-axis and Quantity Ordered on the y-axis.
A scatter chart perfectly plots two continuous variables, revealing patterns across individual records. Pie charts or column charts aggregate data, hiding the granular correlation needed for this analysis.
Q9. A Power BI Data Analyst needs to create a Date table that can be used across multiple reports to filter sales data by different time periods. The table should support filtering by year, quarter, and month. What should the analyst include i…
Answer: D. A continuous range of dates with calculated columns for Year, Quarter, and Month
Date tables require a contiguous date range and calculated columns to support reliable time intelligence. Limiting the table to existing sales dates breaks time intelligence functions and creates gaps in visual timelines.
Q10. You want to implement dynamic Row-Level Security (RLS) in a Power BI dataset. The dataset contains a Users table with the following columns: EmailAddress, Region. You need to restrict access to data based on the logged-in user's email addr…
Answer: D. Create a DAX expression in the RLS role: Users[EmailAddress] = USERNAME().
Using USERNAME in an RLS role dynamically captures the current user's email to filter the Users table. A calculated column fails because RLS security requires strict table filters, not visual logic.
Q11. At GreenLine Analytics, you are tasked with ensuring that the OrderDate column in your dataset has the correct data type and contains no invalid values. What is the most efficient way to validate this in Power BI?
Answer: D. Use the "Column Quality" and "Column Distribution" options in the Query Editor.
Column quality and column distribution provide immediate visual summaries of valid values and anomalies directly within the editor. Fixing errors after loading data using DAX consumes unnecessary memory and ignores source-level optimization.
Q12. At NextWave Analytics, you are building a Power BI report on a large dataset stored in SQL Server. To optimize query performance, you need to allow users to set a date range (Start Date and End Date) for fetching data. How should you modif…
Answer: D. Create two parameters (StartDate and EndDate) and apply them in the SQL query's WHERE clause.
Applying parameters directly inside the SQL WHERE clause pushes the filtering back to the source server through query folding. Using DAX or slicers only filters the data after it has already been fully loaded into memory.
Q13. You are a data analyst at BrightLens Analytics, tasked with preparing raw Excel data for analysis in Power BI. The raw data contains sales figures for two years (2018 and 2019), where the months (January, February, etc.) are listed in rows…
Answer: B. Use the "Use First Row as Headers" option in Power Query.
The Use First Row as Headers option promotes the initial row into column names, setting up a proper table schema. Manually removing rows and renaming columns is inefficient and ignores built-in transformation tools.
Q14. A Power BI Data Analyst has developed a large Power BI report with multiple visuals, including tables, charts, and slicers, based on a dataset with 10 million rows of customer transaction data. Users report that the report is slow to load…
Answer: E. Replace calculated columns with measures where possible, optimize DAX expressions to reduce complexity, and remove unused columns from the data model.
Measures compute dynamically at query time and consume no memory storage, unlike calculated columns which bloat the model size and degrade performance. Removing unused columns further shrinks the VertiPaq cache, making this the optimal strategy for optimizing large, slow datasets.
Q15. BrightMart wants to add a KPI visual that shows "Sales vs Target" with dynamic color coding: Green for above target, Yellow for 90-100%, and Red for below 90%. What is the best way to implement this?
Answer: C. Create a DAX measure using IF statements to return "Green," "Yellow," or "Red," then apply it as a conditional formatting rule in a KPI visual.
Creating a DAX measure with IF statements allows you to return a specific color name or hex code based on dynamic threshold logic. You then apply this measure via conditional formatting so the visual updates its colors automatically as the underlying sales numbers change.
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.