Answer-first summary for fast verification
Answer: No
The solution replaces the original condition with a logically equivalent expression using NOT and COUNTROWS. Both expressions evaluate to the same result, so there is no performance improvement. The community discussion unanimously confirms this with 100% agreement on answer B, noting that the performance remains the same because the logical equivalence does not optimize query execution. Therefore, this solution does not meet the goal of reducing execution time.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a Fabric tenant containing a semantic model named Model1. You find that the provided query is performing slowly against Model1.
You need to reduce the query's execution time.
Solution: Replace line 4 with the following code:
NOT ( CALCULATE ( COUNTROWS ( 'Order Item' ) ) < 0 )
Does this solution meet the goal?
A
Yes
B
No