Câu 31: 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. ✑ 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.)

1. A. Create a multidimensional project and define measures and a many-to-many dimensional relationship. Create partitions in SQL Server Management Studio (SSMS). — đáp án hiện tại
2. B. Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).
3. C. Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).
4. D. Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).