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.
Ensure that the solution supports role-based security and partitions.
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 many-to-many dimensional
relationship. Create partitions in SQL Server Management Studio (SSMS).
B.
Create a multidimensional project and define measures and a reference relationship.
Create partitions in SQL Server Data Tools (SSDT).
C.
Create a tabular project and define measures. Create partitions in SQL Server Data Tools
(SSDT).
D.
Create a tabular project and define calculated columns. Create partitions in SQL Server
Management Studio (SSMS).