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: At EcoMetrics Corp., your inventory report includes the Inventory table with the following columns: Date ProductID Stock. 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 EcoMetrics Corp., your inventory report includes the Inventory table with the following columns: Date Prod…
- A Power BI Data Analyst is importing a CSV file containing customer data with columns for CustomerID, Name, a…
- Imagine you're a data analyst at your company, where the marketing team recently launched a dual-campaign for…
- Which of the following best practices can increase performance in Power BI?
- A Power BI Data Analyst is creating a report with a table visual showing sales data by region and product. Th…
- A Power BI Data Analyst has created a report in Power BI Desktop and published it to a workspace in the Power…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. At EcoMetrics Corp., your inventory report includes the Inventory table with the following columns: Date ProductID StockQuantity Your manager asks you to create a measure that shows the closing stock quantity for the last date in the selec…
Answer: B. Closing Stock = CALCULATE(SUM(Inventory[StockQuantity]), LASTDATE(Inventory[Date]))
CALCULATE modifies the filter context to evaluate the sum of stock quantities specifically for the final date in the current context. LASTDATE returns that latest visible date, making option B the correct DAX pattern. Other options fail to filter by date correctly.
Q2. A Power BI Data Analyst is importing a CSV file containing customer data with columns for CustomerID, Name, and Email. The analyst notices that some CustomerID values appear multiple times due to data entry errors, which could skew analysi…
Answer: B. Apply the "Remove Duplicates" feature on the CustomerID column in Power Query.
Applying Remove Duplicates directly on the CustomerID column in Power Query efficiently drops duplicated rows during data preparation. This ensures data cleanliness before loading the model. Creating DAX calculated columns to handle duplicates is inefficient and skipped during data prep.
Q3. Imagine you're a data analyst at your company, where the marketing team recently launched a dual-campaign for two product lines. They're interested in understanding the simultaneous sales dynamics of these products across various regions…
Answer: C. Cross-filtering hides unrelated data, while cross-highlighting dims them.
Cross-filtering removes unrelated data from the visual entirely, showing only the filtered results. Cross-highlighting retains all data points but dims the unrelated ones, allowing users to compare the highlighted selection against the total context within the visual.
Q4. Which of the following best practices can increase performance in Power BI?
Answer: C. Filter and reduce data early in the transformation process.
Filtering and removing unnecessary columns or rows early in Power Query reduces the memory footprint of the imported dataset. Performing expensive operations before filtering wastes compute resources. Query folding also performs better when you apply filters early.
Q5. A Power BI Data Analyst is creating a report with a table visual showing sales data by region and product. The analyst wants to allow users to filter the table to show only data for a selected year using a slicer. The dataset includes a Da…
Answer: E. Add a slicer visual, select the Year column from the Date table, and set it to dropdown mode.
Adding a slicer visual with the Year column from the Date table allows users to dynamically filter the table, leveraging the existing relationship for accurate filtering. Option A fails because filtering directly on the fact table bypasses the optimized date relationship.
Q6. A Power BI Data Analyst has created a report in Power BI Desktop and published it to a workspace in the Power BI Service. The analyst needs to share the report with a team of colleagues within the organization, ensuring that only authorize…
Answer: C. Share the report by granting the team Viewer access to the workspace in the Power BI Service.
Granting the team Viewer access to the workspace in the Power BI Service allows authorized colleagues to view the report securely online without needing Power BI Desktop. Saving and sharing the .pbix file via a shared drive is incorrect because it exposes the underlying data and requires the desktop application.
Q7. A Power BI Data Analyst is importing a large dataset from a SQL Server database containing product sales data with columns for ProductID, SaleDate, Category, and SalesAmount. The report only needs data for sales in the "Electronics" catego…
Answer: A. Apply filters in Power Query to select only the Electronics category and SaleDate within the last two years before loading.
Applying filters directly in Power Query before loading reduces the dataset size, which improves performance by minimizing memory usage and query execution time. Option C fails because loading the entire dataset into the model defeats the purpose of optimization and consumes unnecessary memory.
Q8. You are preparing a Microsoft Power BI report for a presentation at Ecocentries, and it will be displayed on a widescreen. You're discussing with a colleague about how to adjust the Report page properties for this format. Your colleague as…
Answer: D. Adjust the Canvas Settings to a 16:9 layout.
Adjusting the Canvas Settings to a 16:9 layout changes the report page dimensions to match modern widescreen displays without distortion. The 4:3 layout is incorrect because it represents older square monitor ratios, leaving unused space on modern screens.
Q9. At EcoMetrics Corp., you are reviewing your data model and need to identify the characteristics of a dimension table. Which of the following is a key characteristic of a dimension table?
Answer: A. Contains descriptive attributes such as names and categories.
Dimension tables contain descriptive attributes like names and categories, providing the necessary context to slice and filter fact data. Option B is incorrect because transactional data such as sales amounts and quantities belongs in a fact table, not a dimension table.
Q10. A Power BI Data Analyst is writing a DAX measure that uses the CALCULATE function with multiple filters on different columns of the same table. The analyst needs to understand how these filters will interact. How do multiple filters on dif…
Answer: C. They work together using AND logic (all conditions must be true)
In DAX, multiple filter arguments targeting different columns inside the CALCULATE function combine using AND logic, requiring all conditions to be met. Remember that multiple filters applied to the exact same column use OR logic instead.
Q11. A Power BI Data Analyst has configured Row-Level Security (RLS) roles in a published dataset in Power BI Service. The analyst needs to verify that the RLS roles are working correctly and showing the right data to users in each role. What s…
Answer: A. Use the "View as" feature in Power BI Service to test different roles
The Test as role feature in the Power BI service lets analysts simulate dynamic security groups without needing actual user credentials. This validates exact data restrictions quickly compared to asking users to verify.
Q12. A Power BI Data Analyst has created a line chart showing monthly sales trends across three regions. The chart includes tooltips that display additional details when users hover over data points. The analyst needs to ensure that users who r…
Answer: B. Add alt text descriptions to the visual that include key data insights
Adding alternative text to visual properties provides screen readers a textual summary of the data, ensuring accessibility for visually impaired users. Do not rely on interactive hover elements alone for critical report insights.
Q13. You are working in Power BI and need to create bins for the CustomerAge column. When creating bins in Power BI using this field, what does the "Bin Size" field define?
Answer: B. The range of values included in each bin
The Bin Size parameter determines the numerical interval width distributed across each discrete grouping, such as ten years per age bucket. The alternative option simply sets the total quantity of groups instead.
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.