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:
AC?
B & C
+1
A, E?
Tabular and Power Pivot…
https://technet.microsoft.com/en-us/library/hh213579(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/gg399188(v=sql.110).aspx
Which two of the following options WOULD ALSO BE appropriate for this model? (Choose two).
BC is correct
Incorrect. Power View requires tabular model.
lol Jane really ???
Answer is B and E