Free PL-300 sample questions

Correct answer: Split Column by Delimiter

The 'Split Column by Delimiter' transformation is specifically designed for this purpose. By specifying the hyphen '-' as the delimiter, Power Query will automatically create new columns containing the separated parts of the string. This is the most efficient and direct method for this common data cleaning task.

Correct answer: Create two relationships between the 'Admissions' table and the 'Calendar' table, one active (for Admission Date) and one inactive (for Discharge Date). Use the USERELATIONSHIP function in DAX measures for discharge date analysis.

This is the classic implementation of a role-playing dimension. The 'Calendar' table plays multiple roles (admission calendar and discharge calendar). Power BI only allows one active relationship between two tables. The best practice is to set the primary relationship (e.g., on Admission Date) as active and create an inactive relationship for the secondary date. DAX measures can then activate the inactive relationship on-demand using the USERELATIONSHIP function, allowing for flexible analysis without creating model ambiguity.

Correct answer: The 'Calendar' table has not been marked as a date table in the model.

Time intelligence functions in DAX, such as TOTALYTD, rely on a properly configured date table. If the 'Calendar' table is not officially marked as a date table in the model properties, the DAX engine cannot use its optimized time intelligence algorithms. Instead, it falls back to a much slower, less efficient calculation method, which becomes a significant performance bottleneck on large fact tables. Marking the table as a date table is a critical optimization step.

Correct answer: CALCULATE(SUM(Sales[SalesAmount]), FILTER(ALL(Products), Products[Category] = "Bikes"))

This formula uses the CALCULATE function to modify the filter context. The FILTER function iterates over a table specified by the ALL(Products) function. ALL(Products) removes any existing filters from the 'Products' table, ensuring the calculation considers all products initially. FILTER then applies a new condition to include only rows where the category is 'Bikes'. This correctly isolates the 'Bikes' category sales, ignoring other report filters on the 'Products' table.

Correct answer: ALL

The ALL function is used to remove filters from a table or columns. To create a measure that is unaffected by the 'Campaign Name' slicer, you would wrap the 'Campaigns' table or the 'Campaign Name' column within an ALL function inside a CALCULATE statement. For example: `Total Budget = CALCULATE(SUM(Campaigns[Budget]), ALL(Campaigns))`. This removes the filter context applied by the slicer, ensuring the sum is always calculated over all campaigns.

Correct answer: Create a report page tooltip.

Creating a report page tooltip is the correct solution. You would create a new, smaller report page, enable it as a tooltip in the page settings, and add a visual (like a bar chart) showing sales by salesperson. Then, on the main matrix visual, you would set its tooltip property to use this new report page. This allows for rich, data-driven tooltips that provide additional context on hover.

Correct answer: Implement dynamic Row-Level Security (RLS) using the USERPRINCIPALNAME() DAX function to filter the 'Departments' table based on the logged-in user's email.

Dynamic Row-Level Security (RLS) is the most scalable solution. It involves creating a single security role with a DAX filter expression that dynamically filters data based on the user's identity, typically their User Principal Name (UPN) or email. This requires a lookup table that maps users to their respective departments. This approach allows for a single report to serve all departments while ensuring data is securely filtered, and it is much easier to manage than creating separate reports or static roles for each department.

Correct answer: Live Connection with an on-premises data gateway (standard mode).

A Live Connection is required when connecting to SSAS, as it creates a direct link to the model without importing data or the model structure into Power BI. Because the SSAS instance is on-premises, an on-premises data gateway (in standard mode) is mandatory to act as a bridge, securely relaying queries from the Power BI service to the on-premises SSAS server. This combination ensures real-time data access.

Correct answer: DATEDIFF(Sessions[Session Start Time], Sessions[Session End Time], MINUTE)

The DATEDIFF function is designed to calculate the difference between two dates in a specified interval. The correct syntax is DATEDIFF( , , ). This formula correctly subtracts the start time from the end time and returns the result in minutes.

Correct answers: On the 'Product Details' page, add the 'Product Category' field to the drill-through filter well.; On the 'Product Details' page, enable the 'Drill through' toggle in the page format pane.

The drill-through feature requires you to define the target page ('Product Details') and specify which field will be used to pass the filter context.

This action designates the page as a valid drill-through target, making it appear in the context menu of source visuals.