Question 10
A SQL view has hundreds of millions of rows but only current-quarter purchases are required for this report. Which Power BI approach BEST satisfies the stated requirement?
Explanation
Correct Answer
Folded filtering delegates predicates to the database and reduces transferred rows, supporting push restricted date filters to SQL.
Incorrect Answers
Filter order can preserve upstream database pushdown before an operation prevents further folding. It would address avoid breaking query folding too early, not push restricted date filters to SQL.
Query folding indicators and native statements expose pushdown behavior where supported. That targets verify relational query folding, not push restricted date filters to SQL.
Reusing a controlled source evaluation may reduce repeated requests when supported by the refresh plan. It may suit manage rate-limited API request duplication, not push restricted date filters to SQL.






Microsoft Power BI Data Analyst (PL-300) Practice Tests