nerdexam
Microsoft

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.

Implement and manage data models

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

How the community answered

(40 responses)
  • A
    15% (6)
  • B
    85% (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.

AYes

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

BNoCorrect

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

#Calculation Groups#DAX#Performance Optimization#Data Modeling

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice