MDFT Academy Quizzes

Optimize Slow DAX Query Performance

You work for MDFT Academy, a well-known training agency that uses Microsoft Fabric for data analysis. Your Fabric tenant contains a semantic model named STUDENTMODEL. You discover that the following query performs slowly against STUDENTMODEL:

EVALUATE
    FILTER (
        VALUES ( Student [Student Name] ) ,
        CALCULATE ( COUNTROWS ( 'AttendedCourses' ) ) > 0
    )
    ORDER BY Student[Student Name]

You need to reduce the execution time of the query. Your solution is to replace line 4 with:

NOT ( CALCULATE ( COUNTROWS ( 'AttendedCourses' ) ) = 0)

Does this solution meet the goal?

Choose the correct answer from the options below.

Explanations for each answer:

Yes is incorrect. The proposed solution using NOT (CALCULATE (COUNTROWS('AttendedCourses')) = 0) is logically equivalent to the original query but more complex. It doesn't address the performance issue and adds unnecessary complexity with the negative condition.
No is correct.

Exam Preparation Quiz

Optimize Slow DAX Query Performance