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:
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.