PL-300 Question #168: Real Exam Question with Answer & Explanation

Question

You are designing a Power BI model that uses DirectQuery to connect to an Azure SQL database named sql1. The model will include two tables named Sales and Date. You need to limit the sales data to the last rolling year. The solution must minimize execution times for queries performed against sql1. What should you do?

Options

• AFrom Power Query Editor, add a Relative Year column to the Date table by using a DAX function.
• BCreate a calculated column in the Sales table.
• CAdd a Relative Year column to the Date table.
• DFrom Power Query Editor, use relative date filtering.

Explanation

To efficiently limit sales data to the last rolling year in a DirectQuery model and minimize execution times, apply relative date filtering directly within the Power Query Editor.

Common mistakes.

• A. Adding a Relative Year column using DAX operates after data is queried and loaded into the Power BI model, meaning all data for the year would still be transferred from the source, which does not minimize execution times for the database.

Concept tested. DirectQuery optimization with query folding for filtering

Reference. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-folding

No community discussion yet for this question.