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: At NextWave Marketing, you are creating a Power BI report based on a small dataset stored in an Excel file. Users need q. 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 NextWave Marketing, you are creating a Power BI report based on a small dataset stored in an Excel file. U…
- At SkyMetrics Corp., your manager asks you to calculate the total quantity sold for a specific product catego…
- A Power BI Data Analyst is reviewing a Sales table and discovers that the CustomerName column contains severa…
- A Power BI Data Analyst has created a report based on a shared dataset containing sensitive customer data. Th…
- You are a Power BI developer for Global Analytics Corp. Your company handles sensitive sales data, and your m…
- You published a Power BI report to the Power BI Service for FinTrack Solutions, and it connects to a SharePoi…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. At NextWave Marketing, you are creating a Power BI report based on a small dataset stored in an Excel file. Users need quick access to pre-aggregated data for monthly performance reports. Which connection mode is most appropriate for this…
Answer: C. Import
Import mode is the best choice for small datasets because it caches data in memory for maximum query performance. DirectQuery or live connections are intended for massive datasets or real-time requirements, not small local files.
Q2. At SkyMetrics Corp., your manager asks you to calculate the total quantity sold for a specific product category, "Electronics." The Sales table is linked to the Products table, which contains: ProductID Category The Sales table contains: P…
Answer: C. Total Electronics Quantity = CALCULATE(SUM(Sales[Quantity]), Products[Category] = "Electronics")
The CALCULATE function modifies the filter context, allowing the filter on the Products table to propagate down to the Sales table. The SUMX option fails because it attempts to iterate over Products while aggregating an unrelated Sales column.
Q3. A Power BI Data Analyst is reviewing a Sales table and discovers that the CustomerName column contains several blank values. The analyst needs to address this data quality issue before creating reports. What should the analyst do to handle…
Answer: B. Replace blank values with "Unknown Customer" in Power Query
Replacing blanks with a descriptive placeholder in Power Query resolves the data quality issue without losing entire transactions. Deleting rows with blanks would permanently remove valuable sales records, skewing your aggregate totals.
Q4. A Power BI Data Analyst has created a report based on a shared dataset containing sensitive customer data. The report will be shared with multiple departments via a Power BI app. The analyst needs to minimize the risk of data exfiltration…
Answer: A. Disable the "Export data" option for the report in the Power BI service and share the report via the app with Viewer permission.
Disabling the export data option combined with Viewer permission in the app prevents users from extracting the underlying records. Build permission or enabling data export would defeat the goal of minimizing data exfiltration risks.
Q5. You are a Power BI developer for Global Analytics Corp. Your company handles sensitive sales data, and your manager has requested that you implement Row-Level Security (RLS) to restrict access to specific data based on the user's role. The…
Answer: B. Create a new security role and configure the DAX filter: [Region] == "East" && [Group] == "B".
Creating a new security role with the specified DAX filter cleanly isolates the East region permissions without altering existing roles. Modifying the existing role would accidentally overwrite or broaden the current security boundaries.
Q6. You published a Power BI report to the Power BI Service for FinTrack Solutions, and it connects to a SharePoint Online list. However, the credentials for the SharePoint connection have expired, causing the dataset refresh to fail. What is…
Answer: B. Update the credentials in the dataset settings in Power BI Service.
Updating data source credentials directly in the dataset settings re-establishes the connection without requiring report republishing. Reconnecting via Power BI Desktop is unnecessary and will not fix scheduled refreshes already configured in the service.
Q7. A Power BI Data Analyst needs to calculate year-to-date (YTD) sales in a report. The Sales table has a SaleDate column, but there is no date table in the model. The analyst wants to use DAX time intelligence functions like TOTALYTD. What s…
Answer: C. Create a date table using CALENDAR or CALENDARAUTO function and mark it as a date table
Standard DAX time intelligence functions require a dedicated date table marked as such to establish proper filter context. Relying on Auto Date/Time creates hidden tables that harm performance and limit control over your calculations.
Q8. While reviewing the dataset in Power Query, you want to perform specific tasks based on data profiling insights. You need to decide which data profiling feature to use to complete each task effectively. Which feature will you use to check…
Answer: A. Column Quality
Column Quality explicitly shows the percentage of valid, error, and empty values. Column distribution counts distinct values, and column profile provides overall statistics, but neither isolates nulls as clearly.
Q9. You are reviewing a dashboard that tracks SalesAmount and MarketingSpend by Month, SalesTeam, and Region. The Sum of SalesAmount is displayed in a clustered column chart. If you want to compare the month-over-month percentage change in Sal…
Answer: A. Add a quick measure to calculate the month-over-month change for SalesAmount.
Quick measures generate the underlying DAX for standard time intelligence calculations like month-over-month change. Creating a custom column in Power Query fails because it cannot dynamically adapt to user filter context.
Q10. Lucas currently has Read access to a shared dataset in your Power BI workspace. However, he needs to build his own reports without altering the underlying data model. Which specific permission should you grant him to enable this functional…
Answer: C. Build permission on the dataset
Build permission allows users to create new reports connected to the dataset without modifying the data model. Contributor rights would give excessive access, allowing unwanted changes to the dataset structure.
Q11. A Power BI Data Analyst has published several reports to a Power BI workspace. A business user needs to pin visuals from these reports to create their own dashboard, but should not be able to edit the reports themselves. Which workspace ro…
Answer: B. Viewer
The Viewer role lets business users consume reports and pin visuals to their dashboards without editing rights. Contributor or Member roles would grant unwanted modification access to the underlying reports.
Q12. You are managing a Power BI report for a multinational organization. The report contains sales data for different regions, stored in a table named SalesData. You need to ensure that users can view only the data for their assigned region. W…
Answer: B. Define a DAX filter in the Manage roles settings to filter SalesData by region.
Row-level security requires defining a DAX filter within the Manage Roles settings. A report slicer fails this requirement because users can simply change the filter and view unauthorized regions.
Q13. Your manager wants to analyze the raw data underlying the report visual. However, the "Underlying data" export option is disabled. What should you do to address this?
Answer: C. Request the report author to enable the "Underlying data" option for this report.
Exporting underlying data is a tenant and report-level setting controlled by the author. If disabled, report consumers cannot extract raw row-level data, only summarized data depending on tenant limits.
Q14. At BlueTech Industries, you have published a Power BI report that uses parameters to fetch data for different financial quarters. The CFO asks you to update the parameter for the current quarter to reflect the latest data. What should you…
Answer: B. Modify the parameter value directly in the Power BI Service under the dataset settings.
Power BI Service allows direct updates to configured dataset parameters for quick adjustments. Alternatively, updating and republishing from Power BI Desktop is also technically valid and often preferred for structural source control.
Q15. A Power BI Data Analyst is importing a CSV file containing customer order data into Power BI Desktop. During the data load process in Power Query, the analyst encounters an error indicating that some rows contain invalid date values in the…
Answer: C. Use the "Remove Errors" option in Power Query to skip rows with invalid date values and load the valid data.
Using the Remove Errors option in Power Query removes only the rows containing data type errors, which preserves the rest of the valid dataset. While replacing errors is another valid cleaning technique, it alters the data rather than simply removing the broken rows.
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.