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.
Question
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)- A7% (3)
- B10% (4)
- C81% (34)
- D2% (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.
Configuring measure group relationships is a prerequisite design step that precedes processing, not a standalone verification action in the sequence.
Browsing the cube is a post-processing validation step that can only produce meaningful results after the cube has been processed.
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.
Creating a new measure in the measure group is an additive design action unrelated to verifying an existing Date Key column relationship.
Checking AttributeRelationship properties is a design-time inspection activity, not part of the runtime end-to-end verification sequence.
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
Community Discussion
No community discussion yet for this question.