Câu 19: 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

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

1. A. Create a multidimensional project and define measures and a reference relationship.
2. B. Create a tabular project and define calculated columns.
3. C. Create a multidimensional project and define measures and a many-to-many dimensional relationship. — đáp án hiện tại
4. D. Create a tabular project and define measures.