PL-300 Free Sample Questions

A financial services firm is developing a Power BI report to analyze stock market data. The primary data source is a large Azure SQL Database containing billions of transaction records. The report must provide sub-second query performance for visuals and allow analysts to explore the data using slicers. The data in the database is updated every few minutes. The firm wants to avoid data duplication and minimize data latency. Which storage mode configuration should be used for the main transaction table in the Power BI model?

You are developing a Power BI report for a logistics company. You have two tables: 'Shipments' and 'Carriers'. The 'Shipments' table contains a 'CarrierID' column. The 'Carriers' table contains 'CarrierID' and 'CarrierName'. You need to add the 'CarrierName' to the 'Shipments' table to facilitate analysis. The 'Shipments' table is very large, with over 50 million rows. Which Power Query operation is the most performance-efficient for this task?

You are cleaning a dataset in Power Query that contains a 'ProductSKU' column. The SKU is formatted as 'CAT-ID-SIZE', for example, 'SHRT-105-XL'. You need to extract the three parts ('CAT', 'ID', and 'SIZE') into separate columns. Which transformation provides the most direct way to achieve this?

A hospital analyst is creating a Power BI model to track patient readmissions. The model includes a 'Patients' dimension table and an 'Admissions' fact table. The hospital wants to analyze admissions based on both the admission date and the discharge date. Both dates need to relate to a central 'Calendar' dimension table. How should this be implemented in the data model to avoid ambiguity and follow best practices?

You are optimizing a Power BI data model for a retail company. The model contains a large fact table, 'Sales', with 100 million rows. You notice that several visuals are slow to render. Using Performance Analyzer, you identify that a measure calculating the 'Year-to-Date Sales' is the primary bottleneck. The current DAX formula for the measure is: YTD Sales = TOTALYTD(SUM(Sales[SalesAmount]), 'Calendar'[Date]). What is the most likely cause of the poor performance?

You need to create a measure that calculates the total sales for only the 'Bikes' product category, regardless of any other filters applied to the report, such as year or region. Which DAX formula correctly accomplishes this?

A marketing team wants to analyze campaign performance. They have a report with a slicer for 'Campaign Name'. They want to see a card visual that always shows the total marketing budget for all campaigns, which should not change when they select specific campaigns in the slicer. Which DAX function is essential to create the measure for this card visual?

You are designing a report for a sales manager. The manager wants to see a matrix of 'Sales Amount' by 'Region' and 'Product Category'. When the manager selects a specific region from a slicer, they want a tooltip to appear over the total sales amount for that region, showing a breakdown of sales by individual salesperson within that region. What should you configure to enable this functionality?

A university needs to secure its Power BI reports. Each department (e.g., Engineering, Arts, Medicine) should only see data related to its own students and faculty. The data model has a single 'Departments' table and a single 'FactEnrollment' table. A BI developer needs to implement security so that a user who is a member of the 'Engineering' department can only view 'Engineering' data. What is the most scalable and manageable way to implement this security requirement in the Power BI service?

Your company has a critical sales report built on an on-premises SQL Server Analysis Services (SSAS) tabular model. The report must always display the most up-to-date information without any scheduled delay. You need to publish this report to the Power BI service. Which connection type and gateway configuration must you use?