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 DirectQuery 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 ROLAP (Relational OLAP) storage mode.
D.
An In-Memory query mode.
E.
A SharePoint Server running a PowerPivot workbook.
Explanation: