You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure that includes SQL Server
Analysis Services (SSAS).
The company has a large data warehouse named CorpDW. Terabytes of data are stored in
the fact tables in CorpDW.
The company requires a data model for CorpDW that supports advanced calculations in the
definition of the data model and complex attribute relationships. Advanced calculations
must also be supported in the data model using logic contained in a custom assembly.
You need to design the data model.
Which three of the following options should you include in your design? (Choose three).
A.
Create a tabular model project.
B.
Create a multidimensional model project.
C.
Create multiple partitions for the measure group.
D.
Create multiple groups for the measure group.
E.
Use Data Analysis Expressions (DAX) for the custom logic.
F.
Use Multidimensional Expressions (MDX) for the custom logic.
Explanation:
B, C, F ok