LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Microsoft Fabric Analytics Engineer Associate DP-600

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Ultimate access to all questions.


You have a Fabric tenant containing a semantic model named Model1. You find that the following query executes slowly against Model1.

EVALUATE
SUMMARIZECOLUMNS (
    'Product'[Color],
    FILTER (
        VALUES ( 'Order Item'[Order ID] ),
        CALCULATE ( COUNTROWS ( 'Order Item' ) ) > 0
    )
)

You need to reduce the query execution time.

Solution: Replace line 4 with the following code:

CALCULATE ( COUNTROWS ( 'Order Item' ) ) >= 0

Does this solution meet the goal?

Exam-Like
Quiz related visual


Powered ByGPT-5