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: A Power BI Data Analyst is working with a data model that includes a Sales table (SaleID, CustomerID, SaleAmount) and a . 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 is working with a data model that includes a Sales table (SaleID, CustomerID, SaleAmo…
- A Power BI Data Analyst is designing a data model for a retail company's sales analysis. The dataset includes…
- You are working on a Power BI report for a logistics company to analyze shipment data. The dataset includes t…
- A Power BI Data Analyst is configuring security for a Power BI dataset used by a multinational retail company…
- You have created a Power BI report using an existing data model in Power BI Desktop. Now, you need to publish…
- You have five CSV files in a SharePoint Online folder. Each CSV file contains sales data with the same struct…
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 is working with a data model that includes a Sales table (SaleID, CustomerID, SaleAmount) and a Customers table (CustomerID, CustomerName, Region). The analyst wants to create a report that filters sales by Region…
Answer: E. Create a many-to-one relationship from Sales[CustomerID] to Customers[CustomerID].
Creating a many-to-one relationship from the Sales table to the Customers table ensures filter context correctly propagates downwards. This native model design keeps the dataset efficient and interactive, bypassing the performance penalties of DAX lookups or merged tables.
Q2. A Power BI Data Analyst is designing a data model for a retail company's sales analysis. The dataset includes tables for Sales, Products, Customers, and Dates, with millions of rows in the Sales table. The analyst needs to optimize the mod…
Answer: E. Create a star schema with the Sales table as the fact table, Products, Customers, and Dates as dimension tables, and use a DateKey column to link Sales to Dates.
A star schema with Sales as the central fact table surrounded by dimension tables optimizes in-memory processing and simplifies DAX calculations. Establishing a dedicated Date table ensures native support for time intelligence functions and accurate filtering.
Q3. You are working on a Power BI report for a logistics company to analyze shipment data. The dataset includes the following columns: Shipment ID Order Date Delivery Date Shipment Cost Destination Country You need to: Calculate the number of…
Answer: D. Create a calculated column to calculate the delivery duration and a calculated table to summarize the total shipment cost per country.
Creating a calculated column computes row-level values for each shipment, such as the duration between two dates. Generating a calculated table evaluates DAX to output a summarized grouping, which is perfect for aggregating total cost by country.
Q4. A Power BI Data Analyst is configuring security for a Power BI dataset used by a multinational retail company. The dataset contains sales data, and only regional managers should access their respective region's data, while global executive…
Answer: E. Apply Row-Level Security (RLS) with roles for each region and a role for global executives, assigning users in the Power BI Service, and disable dataset sharing.
Row-Level Security restricts data access at the model level, preventing external tools from bypassing report filters. Creating distinct roles for regions and executives is maintainable, while disabling sharing strictly enforces the intended governance.
Q5. You have created a Power BI report using an existing data model in Power BI Desktop. Now, you need to publish this report to the Power BI Service. What is the most efficient method to achieve this?
Answer: C. Use the Publish button in Power BI Desktop to publish the report to the desired workspace in Power BI Service
Using the Publish button in Power BI Desktop directly uploads the report and dataset to the specified workspace in the service. While uploading a file works, the built-in publish button is the most efficient and standard method.
Q6. You have five CSV files in a SharePoint Online folder. Each CSV file contains sales data with the same structure and columns: Date, Product, Quantity, and Sales Amount. You plan to use Power BI to combine these CSV files into a single tabl…
Answer: B. Use the "SharePoint folder" connector, select the combine option, apply necessary transformations, and load the data into Power BI.
Using the SharePoint folder connector points Power BI directly to the online directory and natively combines the files through a single click. The generic Folder connector requires complex local gateway setups for SharePoint, and manual appends fail to capture newly added files dynamically.
Q7. The executive team at Global Insights Corp. is now concerned about the efficiency of report performance. Some users have complained that critical reports take too long to load, affecting productivity. You decide to compare the "Report Usag…
Answer: B. The "Report Performance" tab measures report load times, while the "Report Usage" tab tracks viewer interactions.
The Report Performance tab tracks how long reports take to open and render, helping identify bottlenecks frustrating users. Conversely, the Report Usage tab monitors viewer statistics like who accessed the report and how often, rather than technical load metrics.
Q8. You have published a Power BI report from an existing data model to the Power BI Service. You need to update the data model and ensure the changes are reflected in the published report. What is the most efficient method to achieve this?
Answer: A. Make changes to the data model in Power BI Desktop, then use the Publish button to overwrite the existing report in Power BI Service
Updating the data model in Power BI Desktop and republishing overwrites the existing dataset and report, seamlessly applying changes. Deleting the report manually is unnecessary and would break existing permissions or subscriptions, making it inefficient.
Q9. You have a Power BI model with a table named Sales. The Sales table contains the following columns: Order Date: Date of the sale. Sales Amount: Total sales amount for each order. Order ID: Unique identifier for each order. You need to crea…
Answer: B. YTD Sales := CALCULATE(SUM(Sales[Sales Amount]), DATESYTD('Sales'[Order Date]))
Using CALCULATE with DATESYTD correctly aggregates the sales amount from the beginning of the year to the latest filtered date. Option C is technically valid but Option B provides the cleaner, more standard DAX pattern without hardcoding dates.
Q10. A Power BI Data Analyst has created a report with a bar chart showing Sales by Region and a card visual showing Total Sales. Currently, when clicking on a region in the bar chart, the card visual does not update. The analyst needs to confi…
Answer: B. Verify that visual interactions are enabled and the card is set to be filtered by the bar chart
Enabling visual interactions allows for the filtering of one visual based on selections made in another. By verifying that visual interactions are enabled and setting the card visual to be filtered by the bar chart, selecting a region in the bar chart will update the card visual accordingly.
Q11. A Power BI Data Analyst needs to set up scheduled refresh for a dataset that connects to an on-premises SQL Server database. The business requires the data to be refreshed every 4 hours during the workday (8 AM to 6 PM). The dataset is pub…
Answer: B. Install and configure an on-premises data gateway, then set up scheduled refresh in Power BI Service
An on-premises data gateway securely bridges Power BI Service to local data sources like SQL Server. Once configured, you can define the 4-hour scheduled refresh intervals natively within the service settings. Cloud migration isn't required, and manual desktop refreshes don't automate enterprise reporting.
Q12. You have a set of CSV files stored in a SharePoint Online folder. You need to load these files into Power BI and combine them into a single dataset. Additionally, the data in these files is updated weekly. What should you do to ensure your…
Answer: C. Use the SharePoint Folder connector and configure a scheduled refresh in Power BI Service
The SharePoint Folder connector natively combines multiple CSV files into a single table within Power Query. Because SharePoint Online is a cloud source, you only need to configure a standard scheduled refresh in the service without relying on a gateway.
Q13. At DataInsights Corp., you need to add a new column named CustomerSegment based on the SalesAmount column. The segmentation logic is as follows: If SalesAmount is greater than 1000, label as "High Value". If SalesAmount is between 500 and…
Answer: B. Use the "Conditional Column" feature in the Query Editor.
Using the Conditional Column feature in the Query Editor provides a visual interface for building nested if-then logic without writing code. This pushes the transformation back to the source, optimizing the model compared to adding a DAX calculated column.
Q14. You've published a Power BI semantic model to a Premium workspace that supports reports for the Finance and Sales teams. The Finance team should have full access to create reports using the semantic model, while the Sales team should only…
Answer: D. Grant the Finance team Build permission on the semantic model and the Sales team Read permission.
Build permission grants users the ability to connect to a published semantic model and create new reports. Read permission limits users to viewing existing reports, preventing them from modifying or building from the model.
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.