DP-500 Question #25: Real Exam Question with Answer & Explanation

Question

Users indicate that when they build reports from the data model, the reports take a long time to load. You need to recommend a solution to reduce the load times of the reports. Solution: You recommend moving all the measures to a calculation group. Does this meet the goal?

Options

• AYes
• BNo

Explanation

Moving existing measures to a calculation group does not inherently reduce report load times; calculation groups primarily simplify DAX logic and management.

Common mistakes.

• A. Calculation groups are a modeling construct for consolidating logic, not a direct performance optimization feature that reduces report load times for existing measures.

Concept tested. Calculation groups performance impact

Reference. https://learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions

No community discussion yet for this question.