nerdexam
Microsoft

70-466 · Question #158

You are designing a SQL Server Analysis Services (SSAS) cube. The cube contains a Time dimension that has a Date attribute. The Date attribute has a default name for the attribute relationship with th

The correct answer is C. Process the cube.. To verify a measure group is correctly tied to the Time dimension in SSAS, you must configure the relationship, process the cube, and then browse it to validate the design.

Build an analysis services database

Question

You are designing a SQL Server Analysis Services (SSAS) cube. The cube contains a Time dimension that has a Date attribute. The Date attribute has a default name for the attribute relationship with the Time dimension named Time. You create a new measure group that contains a Date Key column that references the Date attribute. You need to verify that the measure group is designed correctly and that the Date Key column is tied to the Time dimension. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Options

  • AConfigure the measure group relationships.
  • BBrowse the cube.
  • CProcess the cube.
  • DCreate a new measure in the measure group.
  • ECheck the AttributeRelationship properties.
  • FVerify that the Time dimension values are related to the DateKey column values.

How the community answered

(42 responses)
  • A
    7% (3)
  • B
    10% (4)
  • C
    81% (34)
  • D
    2% (1)

Why each option

To verify a measure group is correctly tied to the Time dimension in SSAS, you must configure the relationship, process the cube, and then browse it to validate the design.

AConfigure the measure group relationships.

Configuring measure group relationships is a prerequisite design step that precedes processing, not a standalone verification action in the sequence.

BBrowse the cube.

Browsing the cube is a post-processing validation step that can only produce meaningful results after the cube has been processed.

CProcess the cube.Correct

Processing the cube compiles and applies all dimension relationship and measure group definitions, making it the essential middle step in the verification sequence. Without processing, changes to the measure group relationships are not deployed and cannot be validated at runtime. This step is required to confirm the Date Key column binding to the Time dimension is functional before browsing results can be trusted.

DCreate a new measure in the measure group.

Creating a new measure in the measure group is an additive design action unrelated to verifying an existing Date Key column relationship.

ECheck the AttributeRelationship properties.

Checking AttributeRelationship properties is a design-time inspection activity, not part of the runtime end-to-end verification sequence.

FVerify that the Time dimension values are related to the DateKey column values.

Verifying Time dimension values against DateKey column values is accomplished through browsing after processing, not as an independent step preceding it.

Concept tested: SSAS measure group dimension relationship verification sequence

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-measure-group-and-measure-properties

Topics

#measure group design#dimension relationship#Time dimension#cube verification

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice