Microsoft
70-467 · Question #26
70-467 Question #26: Real Exam Question with Answer & Explanation
The correct answer is C: Create a multidimensional project and define measures and a many-to-many dimensional. The schema requires bidirectional aggregation between students and classes, which is a classic many-to-many dimensional relationship that SSAS multidimensional projects handle natively.
Question
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic. You have the following requirements: - Ensure that queries of the data model correctly display average student age by class and average class level by student. - Minimize development effort. You need to design the data model. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Exhibit
Options
- ACreate a multidimensional project and define measures and a reference relationship.
- BCreate a tabular project and define calculated columns.
- CCreate a multidimensional project and define measures and a many-to-many dimensional
- DCreate a tabular project and define measures.
Explanation
The schema requires bidirectional aggregation between students and classes, which is a classic many-to-many dimensional relationship that SSAS multidimensional projects handle natively.
Common mistakes.
- A. A reference relationship routes a dimension through an intermediate dimension to the fact table, which does not resolve the bidirectional many-to-many aggregation required between students and classes.
- B. Calculated columns in a tabular project compute row-level derived values but do not define the relational cardinality needed for correct bidirectional aggregation across a many-to-many relationship.
- D. A tabular project using only measures would require complex DAX to replicate many-to-many behavior, increasing development effort rather than minimizing it.
Concept tested. SSAS multidimensional many-to-many dimension relationships
Community Discussion
No community discussion yet for this question.