nerdexam
Microsoft

70-460 · Question #58

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

The correct answer is B. Use the Aggregation Design Wizard. See the full explanation below for the reasoning.

Question

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

Options

  • AUse the CREATE CACHE statement.
  • BUse the Aggregation Design Wizard.
  • CCreate relational indexes on the source tables.
  • DUse the Usage-Based Optimization Wizard.

How the community answered

(28 responses)
  • A
    11% (3)
  • B
    79% (22)
  • C
    4% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice