Microsoft
PL-300 · Question #168
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
Sign in or unlock PL-300 to reveal the answer and full explanation for question #168. The question stem and answer options stay visible for context.
Submitted by rohit_dlh· Apr 18, 2026Prepare the data
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.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DirectQuery#Query Folding#Relative Date Filtering#Performance Optimization