DP-500 · Question #25
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…
The correct answer is B. No. Moving existing measures to a calculation group does not inherently reduce report load times; calculation groups primarily simplify DAX logic and management.
Question
Options
- AYes
- BNo
How the community answered
(40 responses)- A15% (6)
- B85% (34)
Why each option
Moving existing measures to a calculation group does not inherently reduce report load times; calculation groups primarily simplify DAX logic and management.
Calculation groups are a modeling construct for consolidating logic, not a direct performance optimization feature that reduces report load times for existing measures.
Calculation groups organize and simplify repetitive DAX logic, which improves manageability and consistency across reports. However, merely moving existing measures into a calculation group does not directly optimize the underlying data model's performance or inherently reduce the load times of reports that already contain those measures.
Concept tested: Calculation groups performance impact
Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions
Topics
Community Discussion
No community discussion yet for this question.