microsoft pl-300 exam preparation and practice Intermediate Practice Exam: Medium Difficulty 2025

You are building a Power BI report that combines a Sales table from SQL Server and a Targets table from an Excel file stored in SharePoint. The Targets file is updated monthly and sometimes contains extra header rows and inconsistent column names. You need a repeatable approach that ensures the model refreshes successfully in the Power BI service. What should you do?

A dataset uses an imported fact table with 50 million rows. During refresh, you want to reduce the amount of data loaded by filtering to the last 3 years and enable incremental refresh so only new periods refresh. The fact table has an OrderDate column (Date/Time) and a surrogate DateKey column (integer). What should you do?

You have a Sales table with a CustomerID column that contains blanks and inconsistent formatting (some IDs have leading zeros). You also have a Customers dimension table with clean CustomerID values. Relationships are failing for some rows, and totals by customer appear lower than expected. What is the best approach to fix this?

A report uses a Date table and a Sales fact table. The business requires year-over-year (YoY) and month-to-date (MTD) measures that behave correctly with slicers. Some visuals show incorrect time intelligence results. What should you verify or change first?

Your model includes a Sales fact table and a Products dimension. A single product can have multiple tags (e.g., 'Eco', 'Premium'), and users need to filter sales by tag. Tags are stored in a separate table with ProductID and TagName (one row per product-tag). What is the best modeling approach?

You have a measure: Total Sales = SUM(Sales[Amount]). You need a new measure that returns each product’s percentage of total sales within the current slicer context, but ignoring the product filter itself so the denominator is the total for the current selection. What DAX pattern should you use?

A report page includes a clustered column chart by Region and a table of individual customers. Users click a region and expect the customer table to filter to that region, but the table is only being highlighted (showing all customers with partial emphasis). What should you change?

You need a single visual that shows Sales and Profit by Month, but also allows users to quickly spot months where profit margin falls below 10%. The solution should be easy to interpret and not require users to open another page. What should you do?

Executives want to see only aggregated KPIs, while analysts should be able to view row-level customer details. Both groups will use the same published dataset. You need to enforce this in the Power BI service without maintaining separate datasets. What should you implement?

Your team maintains a certified dataset used by multiple reports. You need to reduce refresh failures caused by credential changes and ensure scheduled refresh works after publishing. What is the most appropriate approach?