Exam Preparation Quiz

Optimize DAX Query Performance

You work for MDFT Pro, a well-known training agency. The academy uses a Fabric tenant that contains a semantic model named STUDENTMODEL to track student enrollments and course registrations. You discover that the following query performs slowly against STUDENTMODEL when generating reports for active students:

EVALUATE
    FILTER (
        VALUES ( Customer[Customer Name] ),
        CALCULATE ( COUNTROWS ( 'Order Item' ) ) > 0
    )
    ORDER BY Customer[Customer Name]

You need to reduce the execution time of the query to improve report generation performance. You decide to replace line 4 with the following code:

ISEMPTY ( RELATEDTABLE ( 'Order Item' ) )

Does this meet the goal?

Choose the correct answer from the options below.