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 creating a dashboard for a sales team to monitor monthly revenue. The team wants to receive n. 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 creating a dashboard for a sales team to monitor monthly revenue. The team wants t…
- You are working with two sales tables: AdventureWorksSales and OtherSales. You want to combine the rows from…
- You have created a new workspace in Power BI to host sales reports. You want to add the regional sales manage…
- A Power BI Data Analyst is tasked with securing a Power BI report for a financial services company. The repor…
- A Power BI Administrator needs to give a team member access to a workspace. The team member should be able to…
- Your dataset is updated weekly, and stakeholders need access to the latest insights without manual interventi…
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 creating a dashboard for a sales team to monitor monthly revenue. The team wants to receive notifications if the revenue KPI exceeds a threshold of $500,000 in any month. What should the analyst do to set up thes…
Answer: C. Create a data alert in the Power BI service for the revenue KPI tile, set the threshold to $500,000, and specify email notifications for the team.
Data alerts in the Power BI service can be set on dashboard tiles to trigger notifications when values exceed defined thresholds. Alerts must be created in the service rather than Power BI Desktop, and they do not apply to visual-level filters or subscriptions.
Q2. You are working with two sales tables: AdventureWorksSales and OtherSales. You want to combine the rows from both tables into a single table in Power Query Editor. The image shows the configuration window for the Append Queries operation…
Answer: A. The rows from both tables will be added to a single table.
Appending queries stacks the rows from both tables vertically into a single result set. Merge queries combines columns horizontally based on a matching key, whereas appending does not remove duplicates.
Q3. You have created a new workspace in Power BI to host sales reports. You want to add the regional sales manager as a user who can only view reports and dashboards without making any changes. What role should you assign to the regional sales…
Answer: C. Viewer
The Viewer role restricts users to viewing and interacting with published content without allowing edits. Contributor and Member provide edit permissions, while Admin grants full workspace management rights.
Q4. A Power BI Data Analyst is tasked with securing a Power BI report for a financial services company. The report contains sensitive financial data and is shared with multiple departments, each requiring access only to their respective data…
Answer: D. Implement RLS with dynamic filtering based on USERPRINCIPALNAME(), assign users to roles in the Power BI service, and share the report via a workspace with Viewer permissions.
Using Row-Level Security with dynamic filtering via USERPRINCIPALNAME restricts data access based on the user's login. Sharing via a workspace with Viewer permissions ensures users can consume reports without modifying them. Static filters are harder to maintain than dynamic RLS.
Q5. A Power BI Administrator needs to give a team member access to a workspace. The team member should be able to create and edit reports, but should not be able to delete the workspace or change workspace settings. Which workspace role should…
Answer: B. Contributor
The Contributor role allows users to create, edit, and publish reports within a workspace. It restricts critical administrative tasks like modifying workspace settings or deleting the workspace. The Member role grants unnecessary elevated permissions for these requirements.
Q6. Your dataset is updated weekly, and stakeholders need access to the latest insights without manual intervention. You want to ensure that the Power BI dashboard remains interactive and automatically refreshes with the latest data. What is t…
Answer: B. Publish the dashboard to Power BI Service and share access links.
Publishing to the Power BI Service enables scheduled refreshes to keep data current without manual intervention. Sharing via access links maintains interactivity and manages security efficiently. Emailing static files removes interactivity and fails to scale.
Q7. You are working with two sales tables: AdventureWorksSales and OtherSales. You want to combine the rows from both tables into a single table in Power Query Editor. You proceed to append the AdventureWorksSales and OtherSales tables. Howeve…
Answer: C. Columns with different names will appear as separate columns in the appended table.
Power Query relies on exact column name matching to align data vertically during an append operation. Mismatched names result in separate columns populated with nulls where data is missing. The tool does not automatically map or merge differently named columns.
Q8. You are designing a dimension table for Products at GlobalTrade Corp., which includes ProductID, ProductName, Category, and Subcategory. To ensure your model is normalized, what should you do?
Answer: A. Split the Products table into separate tables for Category and Subcategory.
Normalization involves splitting hierarchical attributes into separate tables to eliminate redundant data. For the PL-300 exam, remember that standard Power BI star schema modeling often favors denormalized dimensions, but this scenario explicitly requires normalization.
Q9. A Power BI Data Analyst has a Product table with a Description column containing text of different lengths. The analyst needs to show the character count for each description in a table visual without adding new columns to the data model…
Answer: D. Create a DAX measure to calculate the length of descriptions
Creating a DAX measure calculates values dynamically at query time without permanently storing data in the model. Calculated columns or Power Query columns consume memory because they are evaluated and stored during data refresh.
Q10. While cleaning the Claims table at HealthConnect Analytics, you find that some rows are missing StateName values. The Claims table includes a StateCode column, and the StateCode table provides corresponding StateName values. Which approach…
Answer: C. Join the Claims table with the StateCode table to look up and fill in missing StateName values
Joining tables in Power Query populates missing data accurately by referencing a reliable lookup table. Excluding rows reduces dataset completeness, and manual entry or visual flags do not resolve the underlying data quality issues.
Q11. A Power BI Data Analyst has created a dashboard and associated reports for a company's finance department and needs to share them with all organizational users for read-only access. The analyst wants to use a Power BI app to distribute the…
Answer: B. Publish the dashboard and reports to a workspace, create an app, and share the app with the entire organization, granting Viewer permission.
Publishing to a workspace and bundling content into an app lets large audiences securely consume read-only datasets. Granting Build permissions allows users to create new reports, while public links bypass enterprise security and governance.
Q12. Your report contains multiple visuals, including a bar chart. When you select a product category in the bar chart, you want all other visuals in the report to display only the data related to the selected category. What should you do to en…
Answer: C. Use the Edit Interactions option to configure interactions between visuals.
The Edit Interactions feature precisely controls how selecting a visual filters other report elements. Drill-through navigates to a separate report page, while slicers require users to manually select values from an independent drop-down menu.
Q13. At DataLens Analytics, you are working on a sales dataset where a single CustomerID can appear multiple times in the Orders table and a single ProductID can appear in multiple orders. How should you design the relationship between the Orde…
Answer: D. Use one-to-many relationships between Customers and Orders and between Products and Orders.
Standard star schema design dictates single-direction one-to-many relationships from dimension tables to the fact table. Bridge tables are reserved for many-to-many cardinalities, which do not apply to this straightforward transactional data model.
Q14. You are building a Microsoft Power BI data model. The Employees table is related to the Departments table through the DepartmentID column. Each employee works in one department, and each department can have multiple employees. You need to…
Answer: D. Set the relationship direction to Single and the Cardinality to One-to-Many (1:*).
A single direction one-to-many relationship is optimal because one department connects to many employees. Single direction filtering provides the best performance and avoids ambiguous filter paths that complicate DAX calculations.
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.