Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 16 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: At DataLens Analytics, you are tasked with creating a measure to calculate the Year-over-Year (YoY) Sales Growth. The Sa. 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
- At DataLens Analytics, you are tasked with creating a measure to calculate the Year-over-Year (YoY) Sales Gro…
- You are building a Power BI dashboard for an e-commerce platform. The dashboard includes a card visualization…
- A Power BI Administrator needs to ensure that sensitive sales reports in the organization are properly classi…
- CASE STUDY: Company A, a retail and manufacturing organization, is undergoing a digital transformation to enh…
- At EcoMetrics Corp., you are tasked with creating a measure to calculate the Year-to-Date (YTD) Sales based o…
- A Power BI Data Analyst is designing a data model for a retail company's sales reporting. The data includes s…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. At DataLens Analytics, you are tasked with creating a measure to calculate the Year-over-Year (YoY) Sales Growth. The Sales table contains SalesAmount and OrderDate. Which DAX formula should you use?
Answer: C. YoY Growth = DIVIDE(SUM(Sales[SalesAmount]) – CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Date[Date])), CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Date[Date])))
This formula correctly calculates year-over-year growth by subtracting last year's sales from current sales, then dividing by last year's sales. Using the DIVIDE function safely handles potential divide-by-zero errors, making it superior to standard division.
Q2. You are building a Power BI dashboard for an e-commerce platform. The dashboard includes a card visualization that displays the average delivery time (in days) for shipped orders. The operations team requests that the font color of the car…
Answer: C. Rules
Rules-based conditional formatting lets you define explicit thresholds and assign specific font colors directly. Color scales are better for gradual transitions, while field values require extra measures, making rules the least complex approach here.
Q3. A Power BI Administrator needs to ensure that sensitive sales reports in the organization are properly classified and protected. The administrator wants to apply labels that indicate the sensitivity level of reports and ensure that these l…
Answer: B. Enable Microsoft Purview Information Protection sensitivity labels in Power BI
Enabling Microsoft Purview Information Protection sensitivity labels allows administrators to classify reports and persist those labels during exports to Excel or PDF. Row-level security restricts row access but does not apply persistent external data classification tags.
Q4. CASE STUDY: Company A, a retail and manufacturing organization, is undergoing a digital transformation to enhance data-driven decision-making. The organization has recently adopted Power BI for analytics and reporting. The analytics team i…
Answer: B. Go to Format → Edit Interactions, click the Bar Chart, and set the interaction with the Pie Chart to "Filter" and the interaction with the Table to "None".
Using Edit Interactions lets you set the Bar Chart to Filter the Pie Chart and None for the Table. Highlight only shades portions of visuals without removing data, and Sync Slicers manages slicer pane items.
Q5. At EcoMetrics Corp., you are tasked with creating a measure to calculate the Year-to-Date (YTD) Sales based on the Sales table, which includes the following columns: OrderDate, SalesAmount. You already have a Date table in your data model…
Answer: D. YTD Sales = CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Date[Date]))
CALCULATE with DATESYTD aggregates sales from the start of the year to the current filter context date. SAMEPERIODLASTYEAR computes prior-year data, while DATESINPERIOD forces a rolling 12-month period backwards.
Q6. A Power BI Data Analyst is designing a data model for a retail company's sales reporting. The data includes sales transactions (OrderID, SaleDate, ProductID, CustomerID, Amount) and related tables for products (ProductID, ProductName, Cate…
Answer: B. Create a fact table with sales transactions and dimension tables for products and customers, linked by ProductID and CustomerID in a star schema.
A star schema centers on a sales fact table connected directly to products and customers dimension tables. Flattening tables into a single model degrades performance and scalability, while ignoring relationships prevents filtering.
Q7. You are preparing a Power BI report for a retail company. The company wants to monitor historical sales for each product category over the past two years and predict sales trends for the next 12 months. Which visual is most appropriate for…
Answer: D. Line chart with forecasting enabled
A line chart is designed for visualizing trends over time. The built-in forecasting feature allows you to predict future data points, making it the best choice here. Other visuals like waterfall or bar charts lack native time-series forecasting.
Q8. You are working on a Power BI report for EcoSolutions Corp. that combines data from two sources: ✔ A local Excel file ✔ A web-based API Upon refreshing the report, you encounter a Privacy Level error due to mismatched privacy levels betwee…
Answer: B. Set the Privacy Level of both data sources to "Organizational" in the Privacy Level settings.
Setting both data sources to the Organizational privacy level allows Power BI to combine the data securely while respecting privacy boundaries. Setting mismatched levels or marking internal business data as Public can trigger firewall errors or create security risks.
Q9. You have a dataset containing the number of new subscribers and cancellations per month for a subscription-based service. You want to create a visualization to compare the number of new subscribers and cancellations on a monthly basis (sho…
Answer: C. Line chart
A line chart is the most effective visualization for comparing metrics across time because it clearly represents trends and patterns. While bar charts show comparisons, line charts are the standard Power BI visual for continuous time-based data like months.
Q10. You are a data analyst at OptiMetrics Inc., and your team wants to ensure data quality before creating a report. You need to evaluate a dataset in Power BI to check for missing values, column distributions, and the minimum and maximum valu…
Answer: B. Query Editor > Data Profiling View
The Data Profiling feature in Power Query Editor provides an in-depth analysis of column properties, including value distributions and missing values. This tool is essential for data quality assessment before report creation, unlike slicers or dataset settings.
Q11. You are building a university enrollment report in Power BI Desktop. The data model includes two tables: Students and Courses. Both tables have Row-Level Security (RLS) configured and are filtered by Department. You need to create a relati…
Answer: B. Create an active relationship and enable "Apply security filter in both directions" for the relationship.
Enabling Apply security filter in both directions ensures that row-level security filters propagate correctly across the relationship. Standard cross-filtering handles general data filtering, but the specific security checkbox is required to guarantee RLS rules apply bidirectionally.
Q12. A Power BI Data Analyst is connecting to a SQL Server table that contains 150 million transaction records. The analyst needs to import only a sample of the data into Power BI Desktop for development and testing purposes to improve performa…
Answer: B. Use a native SQL query with a WHERE clause or TOP statement in Power Query
Writing a native SQL query with a WHERE clause or TOP statement pushes data reduction back to the source server, ensuring only a sample is imported. Applying filters after loading data into Power Query or DAX still attempts to pull the full dataset initially.
Q13. You are building a Power BI report for a logistics company. The company stores its delivery data in a custom-built NoSQL database system. While working in Power BI Desktop, you find that there is no specific Get Data connector for this dat…
Answer: D. Use the Web connector to pull data from the API.
The Web connector is the correct choice to retrieve data from a REST API endpoint. The OData connector fails because it only works with APIs compliant with the OData protocol, and the JSON connector only reads static files.
Q14. You are creating a Power BI report for a restaurant chain. The management team wants to track the revenue for the same period last year and compare it with the current period. You already have a measure named Revenue to calculate the reven…
Answer: C. CALCULATE([Revenue], SAMEPERIODLASTYEAR(Date[Date]))
The SAMEPERIODLASTYEAR function shifts the filter context back exactly one year to evaluate the measure. PARALLELPERIOD is a strong distractor but operates at the level of the entire year rather than matching the exact granular date range.
Q15. A Power BI Data Analyst is working with two tables in Power Query: an Employee table (EmployeeID, Name, DepartmentID) and a Department table (DepartmentID, DepartmentName). The analyst needs to combine these tables so that all employees ap…
Answer: A. Left Outer join with Employee table as the left table
A Left Outer join ensures every row from the primary Employee table is preserved in the merged output. An Inner join would incorrectly drop employees lacking matching department records, violating the core requirement.
Q16. A Power BI Data Analyst is working with a Sales table that contains columns for SalesAmount and Cost. The analyst needs to create a new column that calculates the profit for each row by subtracting Cost from SalesAmount. Which feature shou…
Answer: B. Create a calculated column using DAX in the Sales table
Creating a calculated column using DAX evaluates the subtraction expression row by row to store the profit directly in the table. A measure aggregates data on the fly and does not create a new physical column for each row.
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.