You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM) that will be
used by company employees to create Power View reports.
The model will pull data from data hosted on a single SQL Server. As the volume of data is small
and static, you decide to configure the project to use the query mode of In-Memory and the project
type of Tabular.
Which two of the following options would also be appropriate for this model? (Choose two).
A.
A tabular project type.
B.
A multidimensional project type.
C.
A MOLAP (Multidimensional OLAP) storage mode.
D.
A ROLAP (Relational OLAP) storage mode.
E.
A SharePoint Server running a PowerPivot workbook.
Explanation: