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.)
A.
Create a multidimensional project and define measures and a reference relationship.
B.
Create a tabular project and define calculated columns.
C.
Create a multidimensional project and define measures and a many-to-many dimensional
relationship.
D.
Create a tabular project and define measures.
many – to – many