Question 168 of 388
Single answerYou 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?
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.
✓
Correct Answer: D
From Power Query Editor, use relative date filtering.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.