nerdexam
Microsoft

70-466 · Question #149

You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube. Data is one of the existing dimensions in the SSAS database. The un

The correct answer is C. Create cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the existing Date dimension in the database.. Role-playing dimensions in SSAS allow a single physical dimension to be reused multiple times in a cube under different names, enabling multiple date relationships without extra processing overhead.

Build an analysis services database

Question

You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube. Data is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including InvoiceDate DueDate and PaymentDate. You need to ensure that users can slice the Accounts Receivable measures by InvoiceDate, DueDate, and PaymentDate. 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 three new perspectives named InvoiceDate, DueDate, and PaymentDate.
  • BCreate three independent dimensions named InvoiceDate, DueDate and PaymentDate and then add all three of them to the Accounts Receivable measure group.
  • CCreate cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the existing Date dimension in the database.
  • DAdd three attributes named InvoiceDate, DueDate, and PaymentDate to the existing Date dimension in the database.

How the community answered

(42 responses)
  • A
    7% (3)
  • B
    14% (6)
  • C
    74% (31)
  • D
    5% (2)

Why each option

Role-playing dimensions in SSAS allow a single physical dimension to be reused multiple times in a cube under different names, enabling multiple date relationships without extra processing overhead.

ACreate three new perspectives named InvoiceDate, DueDate, and PaymentDate.

Perspectives are virtual views that subset cube objects for user convenience; they do not create new dimensional relationships or allow slicing by additional date attributes.

BCreate three independent dimensions named InvoiceDate, DueDate and PaymentDate and then add all three of them to the Accounts Receivable measure group.

Creating three fully independent dimensions requires processing three separate dimension datasets, which increases rather than minimizes processing time.

CCreate cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the existing Date dimension in the database.Correct

Creating cube dimensions named InvoiceDate, DueDate, and PaymentDate that all reference the existing Date database dimension creates role-playing dimensions - aliases of one physical dimension. Because the underlying dimension data is processed only once, processing time is minimized compared to creating independent dimensions, while still enabling independent slicing by each date type.

DAdd three attributes named InvoiceDate, DueDate, and PaymentDate to the existing Date dimension in the database.

Adding multiple date attributes to a single dimension conflates the date roles into one dimension, preventing independent hierarchical slicing by InvoiceDate, DueDate, and PaymentDate as separate dimensions.

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#date dimension#measure group relationships#cube dimensions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice