Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 13 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: You are reviewing the "Adventure Works Product Sales Report 2023" on the Power BI service. You want to pin the Order Tot. 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 reviewing the "Adventure Works Product Sales Report 2023" on the Power BI service. You want to pin th…
- You are a data analyst at MarketLens Inc. working on a report that analyzes sales performance. Your manager h…
- A Power BI Data Analyst is building a report to visualize sales data by product category. The data model incl…
- You are reviewing the dataset in Power Query using Data Profiling Tools. The ProductName column has 25 distin…
- A Power BI Data Analyst is working with a Customer table that has an Email column. The analyst needs to quick…
- A colleague suggests that instead of using Quick Measures, you should write a custom DAX formula for the Runn…
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 reviewing the "Adventure Works Product Sales Report 2023" on the Power BI service. You want to pin the Order Total by Product Color line chart to a dashboard for quick access. What action should you take to pin the Order Total by P…
Answer: D. Click the Pin visual icon on the visual.
Clicking the pin visual icon is the direct way to add a report visual to a Power BI service dashboard. Dashboards are exclusively built from pinned visuals, so editing options or exporting to Excel are invalid workflows.
Q2. You are a data analyst at MarketLens Inc. working on a report that analyzes sales performance. Your manager has provided a dataset that includes Category Name, SubCategory Name, and TotalSales. The manager requests a visual that displays s…
Answer: D. Select the Category Name field, click "New Hierarchy," and add SubCategory Name to it.
Creating a hierarchy explicitly defines the parent-child relationship, enabling seamless drill-down navigation in visuals. Dragging separate fields onto an axis creates a flat cross-product display instead of a true drillable structure.
Q3. A Power BI Data Analyst is building a report to visualize sales data by product category. The data model includes a Sales table with a ProductID column (stored as text) and a Product table with a ProductID column (stored as a whole number)…
Answer: B. Change the ProductID column in the Sales table to whole number in Power Query and create a many-to-one relationship to the Product table.
Relationships require matching data types, so changing the Sales ProductID to whole number in Power Query enables the many-to-one connection. Calculated columns or many-to-many relationships introduce unnecessary model complexity.
Q4. You are reviewing the dataset in Power Query using Data Profiling Tools. The ProductName column has 25 distinct values and 14 unique values with no errors or empty entries. The column profiling feature displays the value distribution in th…
Answer: D. There are duplicate entries in the ProductName column.
When distinct values exceed unique values, some items appear multiple times. Distinct counts all different values, while unique counts only items appearing exactly once, proving duplicates exist.
Q5. A Power BI Data Analyst is working with a Customer table that has an Email column. The analyst needs to quickly identify which email addresses appear multiple times in the table to review data quality issues before building reports. What s…
Answer: A. In Power Query Editor, group by Email and count rows to identify emails with count greater than 1
Using Power Query to group by the Email column and count rows efficiently identifies duplicates. Grouping in data preparation is faster and cleaner than writing complex DAX or manually inspecting rows.
Q6. A colleague suggests that instead of using Quick Measures, you should write a custom DAX formula for the Running Total to have more control over the calculation logic. Which of the following DAX functions is most commonly used to calculate…
Answer: A. CALCULATE
CALCULATE modifies the filter context, making it essential for manual cumulative calculations. While ALL removes filters, it relies on CALCULATE to apply the modified context to the base aggregation.
Q7. You are building a Power BI report for EcoMetrics Corp. and need to calculate the total sales for all transactions in the Sales table. The Sales table includes the following columns: SalesAmount Quantity OrderID What DAX formula should you…
Answer: B. Total Sales = SUM(Sales[SalesAmount])
The SUM function correctly aggregates the values in the SalesAmount column to compute total sales. While CALCULATE could also work, SUM is the direct and most efficient choice for simple aggregation. Other options either calculate an average or sum the wrong column.
Q8. What is the purpose of the "Copy query" option in the Performance Analyzer?
Answer: B. To copy the DAX query so it can be edited in an external tool like DAX Studio.
The Copy query feature in Performance Analyzer extracts the exact DAX query generated by a visual. This allows developers to paste and analyze it in external tools like DAX Studio for performance tuning. It does not copy the visual itself or export data results.
Q9. You are developing a Power BI report for BrightLens Manufacturing, where sales data is stored in a shared semantic model (Analysis Services Tabular), and inventory data is stored in a cloud-based database. The sales team wants a combined r…
Answer: A. Use a live connection to the semantic model and import inventory data into Power BI Desktop.
A DirectQuery or live connection can be combined with imported data using composite models in Power BI Desktop. Using Excel exports defeats the purpose of dynamic reporting, while separate linked dashboards do not provide a unified visual experience.
Q10. At SkyMetrics Corp., your dataset includes customer purchasing data with the following columns: CustomerID, Total Purchases, Average Purchase Value, and Purchase Frequency. Your manager wants to identify clusters of customers with similar…
Answer: C. Use the "Clustering" feature in the Analytics pane for the visual displaying customer purchasing data.
The built-in clustering feature in the Analytics pane automatically groups scatter chart data points based on selected metrics. Manually creating groups or building complex calculated tables is unnecessarily rigid and misses native automated detection.
Q11. You are responsible for maintaining a Power BI report that tracks employee performance metrics. The PBIX file is 400 MB, and the dataset includes data from the last 5 years, containing over 15 million rows. The report is hosted in a Premiu…
Answer: C. Reduce the data model size by removing unnecessary columns and rows.
Trimming the data model by removing unused columns and historical rows directly improves processing speed for both rendering and filtering. Changing refresh frequencies or swapping slicers for filters does not reduce the underlying memory footprint.
Q12. A Power BI Data Analyst has a Customer table with an Email column. The analyst needs to create a calculated column that shows "Duplicate" if an email address appears more than once in the table, and "Unique" if it appears only once. Which…
Answer: D. IsDuplicate = IF(COUNTROWS(FILTER(Customer, Customer[Email] = EARLIER(Customer[Email]))) > 1, "Duplicate", "Unique")
Using EARLIER inside a FILTER function correctly compares the current row's email against all other rows to find matches. Simple aggregations like COUNT evaluate the entire column rather than analyzing data row by row for duplicates.
Q13. You are an analyst at DataFlow Analytics, and your organization uses both Power BI Pro and Power BI Premium licenses. While working in Power BI Service, you notice that some workspaces (e.g., "Power BI Onboarding" and "Hardware Security")…
Answer: A. The workspace is part of a Power BI Premium capacity.
The diamond icon indicates the workspace is backed by a Premium or Fabric capacity. This allows free-license users to consume content in that specific workspace. Certified datasets are marked with a badge, not a workspace diamond.
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.