Free PL-300 sample questions
Each free PL-300 sample question below comes with the correct answer and an explanation. Topics range from cleaning data in Power Query to writing DAX and securing workspaces. Try a few before you study to find your weakest area.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
You have a Power BI report that contains three pages: 'Overview', 'Sales Details', and 'Product Details'. You want to allow users to right-click a product category on a chart in the 'Overview' page and navigate directly to the 'Product Details' page, with that page automatically filtered to the selected product category. Which feature should you configure? (Select TWO).
You are creating a report for an HR department. You need to display employee headcount over time. Headcount is a semi-additive measure; it should sum up across all dimensions like department and location, but it should not be summed up over time. Instead, it should show the last known headcount for any given time period (e.g., the headcount at the end of the month). Which combination of DAX functions is best suited for creating this semi-additive measure?
True or False: When you publish a Power BI report from Power BI Desktop to a workspace in the Power BI service, the underlying dataset is published as a separate object that can be reused by other reports.
A data analyst has created a Power BI report connected to a sales dataflow. To improve usability, the analyst wants to enable report consumers to change the measures displayed in a chart (e.g., switch from 'Sales Amount' to 'Quantity Sold' or 'Profit Margin'). What Power BI feature should be used to achieve this dynamic measure selection with minimal DAX complexity?
You are importing a JSON file containing nested data about customer orders. The file structure has a top-level array of orders, and each order object contains a nested array of line items. In Power Query, after connecting to the JSON file and converting it to a table, what is the next critical step to correctly flatten the data so that you have one row per line item?
You have a Power BI dataset connecting to an Azure Synapse Analytics SQL pool using DirectQuery. Users report that a specific matrix visual with many measures is extremely slow. The data engineering team has confirmed the underlying database is performing well. You need to diagnose which specific element within the Power BI report is causing the slowdown. What is the most effective tool within Power BI Desktop for this purpose?
You are building a report that includes a line chart showing sales over time. To help users understand the data, you need to add a horizontal line representing the average sales for the entire period shown on the chart. Which feature in the Visualizations pane should you use?
A project manager wants a Power BI dashboard that provides an at-a-glance view of key project metrics from multiple reports. The manager needs to receive an email with a snapshot of the dashboard every Monday morning and also be notified immediately if the 'Projects Over Budget' KPI exceeds 10. Which TWO features of the Power BI service should be configured to meet these requirements? (Select TWO).
Case Study: Global Retail Corp **Company Background:** Global Retail Corp is a multinational retailer with operations in North America, Europe, and Asia. They have a central data warehouse built on Azure Synapse Analytics which houses sales, inventory, and customer data. Each region operates semi-autonomously, maintaining its own product categorization in local ERP systems. The company is standardizing its analytics on Power BI. **Current Situation:** A central BI team is building a global sales report. They are connecting to the Azure Synapse data warehouse using DirectQuery to ensure data is always current. A significant challenge is that product categories differ across regions. For example, the same product might be 'Electronics' in North America, 'Électronique' in Europe, and '電子製品' in Asia. The company wants a single, unified 'Global Category' slicer in the report. **Requirements:** 1. The model must maintain a DirectQuery connection to the main sales fact table in Azure Synapse to ensure real-time data. 2. A mapping table, which translates regional categories to a standardized global category, is maintained in a SharePoint list and is updated infrequently. 3. The final report must not show regional category names, only the standardized global categories. 4. The solution must be performance-efficient, minimizing the impact on the DirectQuery source. Which data modeling approach best satisfies all the requirements? graph TD subgraph Azure Synapse (DirectQuery) FactSales[FactSales] DimProduct[DimProduct] end subgraph SharePoint (Import) CategoryMap[Category Mapping List] end subgraph Power BI Model Report --> Model end FactSales --> Model DimProduct --> Model CategoryMap --> Model Internet((User)) --> Report
10 more free samples are waiting
Create a free account to unlock the whole PL-300 sample bank, or get full access to all 261 practice questions in the simulator.