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.
