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: You are developing a Power BI report for a global sales team. The dataset includes a Regions table, and you need to impl. 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
- You are developing a Power BI report for a global sales team. The dataset includes a Regions table, and you n…
- A Power BI Data Analyst is tasked with creating a dataset that combines sales data from two tables in an Azur…
- CASE STUDY: Company A, a retail and manufacturing organization, is undergoing a digital transformation to enh…
- A Power BI Data Analyst needs to create a report using data from a Microsoft Dataverse table. The report will…
- You are creating a Power BI dashboard for a hospital management system. A report page includes the following…
- A Power BI Data Analyst is creating a report that connects to a cloud-based sales database. The database is u…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. You are developing a Power BI report for a global sales team. The dataset includes a Regions table, and you need to implement Row-Level Security so that each user only sees data for their assigned region. Which steps should you follow to i…
Answer: D. Create a role with a DAX filter on the Regions table that restricts data based on the user's email address.
Creating a DAX role that filters by USERPRINCIPALNAME() correctly restricts access based on the logged-in user. Filtering visuals manually or removing rows in Power Query will not dynamically adapt per user and breaks the dynamic security model required for shared datasets.
Q2. A Power BI Data Analyst is tasked with creating a dataset that combines sales data from two tables in an Azure SQL Database: a Sales table (SaleID, ProductID, SaleDate, Amount) and a Products table (ProductID, ProductName, Category). The a…
Answer: B. Use Power Query to load both tables, merge them with a Left Outer join on ProductID, and configure a daily refresh in Power BI Service.
A Left Outer join on ProductID ensures every Sales record is preserved regardless of matches, satisfying the inclusion requirement. Inner joins drop unmatched rows, while mixed or Full Outer joins add complexity and unneeded data.
Q3. 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: D. Use sensitivity labels to classify and protect sensitive data in reports and datasets.
Sensitivity labels classify and protect reports and datasets by enforcing encryption and access policies. Isolating secure workspaces or giving broad Build permissions fails to provide systematic, organization-wide data protection.
Q4. A Power BI Data Analyst needs to create a report using data from a Microsoft Dataverse table. The report will be shared with team members through Microsoft Teams. The analyst wants to ensure the data refreshes automatically each day. What…
Answer: D. Install the Power BI Desktop application and use the Dataverse connector
Using the native Dataverse connector in Power BI Desktop provides direct, secure access to tables for modeling and reporting. SQL or custom API connections are not recommended, and Excel exports create static snapshots.
Q5. You are creating a Power BI dashboard for a hospital management system. A report page includes the following visuals: a line chart showing patient admissions over time, a bar chart showing patient admissions by department, and a map showin…
Answer: D. Pin the report page as a live tile on the dashboard.
Pinning the entire report page as a live tile preserves cross-filtering and interactivity directly within the dashboard. Exporting to PDF or images creates static snapshots, and sharing a report link bypasses the dashboard entirely.
Q6. A Power BI Data Analyst is creating a report that connects to a cloud-based sales database. The database is updated every few hours, and the analyst wants to ensure good report performance while keeping the data reasonably current. The dat…
Answer: A. Import mode
Import mode provides the fastest performance for moderate datasets by caching data in memory, with scheduled refreshes meeting the currency needs. DirectQuery slows visuals down, and Live Connection targets Analysis Services.
Q7. You are building a Power BI report for a human resources (HR) department. The HR team wants to analyze employee attrition to identify the factors driving employee resignations. The dataset includes the following columns: Employee ID Resign…
Answer: C. Key influencers
The Key Influencers visual uses machine learning to analyze data and automatically identifies the factors driving a specific metric. A decomposition tree requires manual exploration, while standard charts lack automated ranking capabilities. Rely on Key Influencers for quick statistical insights.
Q8. A Power BI Data Analyst is working with two tables in Power Query: an Orders table (OrderID, CustomerID, OrderDate) and a Customers table (CustomerID, CustomerName, Region). The analyst needs to combine these tables so that all orders appe…
Answer: B. Merge the Orders table with the Customers table using a Left Outer join
Merging the Orders table with the Customers table using a Left Outer join retains all rows from the left table regardless of matches. An inner join drops unmatched orders, while appending stacks tables vertically instead of combining them by matching keys. Always rely on left outer joins to preserve base records.
Q9. A Power BI Data Analyst needs to combine three CSV files containing sales data from different regions (each with columns: OrderID, SaleDate, Amount, Region) into a single table for reporting. All files have the same structure and are store…
Answer: A. Use the Folder connector in Power Query to import all CSV files from the folder, combine them into a single table, and enable data refresh.
The Folder connector in Power Query automatically combines all files within a directory and captures new files added later during scheduled refreshes. Manually importing and appending individual files creates maintenance overhead. For the exam, always choose the Folder connector when combining files.
Q10. At EcoMetrics Corp., you are tasked with creating a common date table to be used across multiple fact tables, including Sales and Inventory. The table must include date-related columns for filtering and analysis. Which of the following is…
Answer: D. The table must have a column with unique and contiguous dates.
A designated date table must contain a column of unique, contiguous dates to serve as the primary key for relationships. This contiguous range is mandatory for time intelligence functions to work correctly and prevents gaps in date filtering.
Q11. 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: D. Enable the Anomaly Detection feature in the line chart, configure the Sensitivity setting, and review the automatically generated explanations.
The built-in Anomaly Detection feature on line charts uses machine learning to automatically find outliers and provides explanations. Configuring the sensitivity slider adjusts the detection threshold without requiring custom DAX. This native tool precisely meets the automated analysis requirements.
Q12. At SkyMetrics Corp., your report includes a Global Sales Summary page and two drillthrough pages: Product Details: Filters by Product Category. Customer Details: Filters by Customer Name. Your manager requests that when selecting a product…
Answer: C. Create separate drillthrough pages for Product Category and Customer Name and configure each with the appropriate field in the "Drillthrough" section.
Creating separate drillthrough pages allows you to define specific filter fields in the Drillthrough pane for each destination. Combining them on one page would force users to pass both filters simultaneously. This ensures the drillthrough targets match the intended visual context.
Q13. A Power BI Data Analyst is tasked with creating a report that summarizes metadata (file name, creation date, and row count) from multiple CSV files in a folder without loading the actual data content into Power BI. The report should update…
Answer: A. Use the Folder connector, filter to CSV files, select metadata columns (Name, Date Created), and add a custom column to count rows without loading content.
Using the Folder connector and extracting metadata without loading the binary content is the correct approach to summarize file properties. This approach uses query folding to keep the dataset lightweight. Loading the actual data would violate the requirement and degrade performance.
Q14. A Power BI Data Analyst is building a report to visualize monthly sales trends from an Azure SQL Database containing a Sales table (SaleID, SaleDate, Amount, Region). The report should be published to the Power BI Service for team access a…
Answer: D. Connect to the Azure SQL Database using Import mode, create the report in Power BI Desktop, publish to the Power BI Service, and configure a daily refresh with SQL Server credentials.
Import mode with a scheduled refresh in the Power BI Service provides the best balance of performance and secure data access. While DirectQuery offers real-time data, it introduces setup complexity. Sharing a local file via email bypasses central governance and secure credential management.
Q15. A Power BI Data Analyst is working with a CSV file containing sales data (OrderID, SaleDate, Amount) to create a report showing monthly sales trends. The SaleDate column is in the format "MM/dd/yyyy" (e.g., 07/15/2025) but is stored as tex…
Answer: B. Change the SaleDate column type to Date, then mark it as a Date Table and create a date hierarchy in Power BI Desktop.
Changing the data type to Date properly converts the text into recognizable dates for temporal analysis. Marking the table as a date table activates time intelligence functions and enables reliable drill-down hierarchies, whereas extracting text strings breaks chronological sorting.
Q16. You are developing a Power BI report for a multinational company. The imported dataset contains a Date column stored as text with inconsistent formats (e.g., "dd/mm/yyyy" and "mm/dd/yyyy"). You need to standardize these values in Power Que…
Answer: A. Use the Change Type Using Locale option in the Transform tab, selecting a locale that matches the source data format.
Using the Change Type Using Locale option correctly interprets ambiguous dates by applying the specific regional formatting of the source data. Manually changing the type to Date assumes local system settings, which can silently misinterpret days and months.
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.