nerdexam
Microsoft

70-466 · Question #16

You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube. Date is one of the existing dimensions in the SSAS database. The underl

The correct answer is A. Create cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.. SSAS role-playing dimensions allow a single database dimension to be reused multiple times in a cube under different names, minimizing processing time while enabling multiple date navigation paths.

Build an analysis services database

Question

You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube. Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You need to ensure that users can view the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • ACreate cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.
  • BCreate three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.
  • CCreate three new perspectives named FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
  • DAdd three attributes named FirstServiceDate, SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.

How the community answered

(23 responses)
  • A
    65% (15)
  • B
    9% (2)
  • C
    9% (2)
  • D
    17% (4)

Why each option

SSAS role-playing dimensions allow a single database dimension to be reused multiple times in a cube under different names, minimizing processing time while enabling multiple date navigation paths.

ACreate cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.Correct

Creating named cube dimensions from the existing Date database dimension produces role-playing dimensions - FirstServiceDate, SecondServiceDate, and ThirdServiceDate each reference the same underlying dimension object. Because only one dimension exists at the database level, it is processed once rather than three times, satisfying the requirement to minimize processing time while giving users three distinct date-based navigation paths for the Service Quality measure group.

BCreate three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.

Three independent dimensions are three separate database objects that must each be fully processed, significantly increasing total processing time compared to reusing a single shared dimension.

CCreate three new perspectives named FirstServiceDate, SecondServiceDate, and ThirdServiceDate.

Perspectives are virtual subsets of an existing cube and do not create new dimension-to-measure-group relationships or enable navigation by different date roles.

DAdd three attributes named FirstServiceDate, SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.

Adding attributes to the existing dimension does not establish separate dimension-to-measure-group relationships, so users would not be able to independently navigate by FirstServiceDate, SecondServiceDate, and ThirdServiceDate in the Service Quality measure group.

Concept tested: SSAS role-playing dimensions for multiple date relationships

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-a-regular-relationship-and-regular-relationship-properties

Topics

#role-playing dimensions#cube dimension reuse#processing time#multiple date attributes

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice