nerdexam
Microsoft

70-467 · Question #82

You need to implement the aggregation designs for the cube. What should you do?

The correct answer is B. Use the Aggregation Design Wizard. The Aggregation Design Wizard in SSAS is the tool used to define and optimize aggregations for a cube partition based on performance goals.

Design BI data models

Question

You need to implement the aggregation designs for the cube. What should you do?

Options

  • AUse the Usage-Based Optimization Wizard.
  • BUse the Aggregation Design Wizard.
  • CPartition the cube by month.
  • DImplement cache warming in SSAS via an SSIS package.

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    90% (26)
  • C
    3% (1)

Why each option

The Aggregation Design Wizard in SSAS is the tool used to define and optimize aggregations for a cube partition based on performance goals.

AUse the Usage-Based Optimization Wizard.

The Usage-Based Optimization Wizard relies on existing query log data to refine aggregations after the cube is in use; it cannot be used for initial aggregation design without prior usage history.

BUse the Aggregation Design Wizard.Correct

The Aggregation Design Wizard allows you to specify a performance gain target or storage limit and then automatically designs aggregations for cube partitions. It works at design time to pre-compute summaries that speed up MDX query response, which is the correct tool for implementing aggregation designs.

CPartition the cube by month.

Partitioning the cube by month is a data management and scalability strategy, not a method for designing aggregations.

DImplement cache warming in SSAS via an SSIS package.

Cache warming via SSIS pre-loads the SSAS cache with query results but does not define or create aggregation designs for the cube.

Concept tested: SSAS aggregation design wizard for cube optimization

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/designing-aggregations-analysis-services

Topics

#SSAS aggregations#Aggregation Design Wizard#Usage-Based Optimization#cube performance

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice