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?
0
0
B & C
0
0
+1
0
0
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
0
0
Which two of the following options WOULD ALSO BE appropriate for this model? (Choose two).
BC is correct
0
0
Incorrect. Power View requires tabular model.
0
0
lol Jane really ???
0
0
Answer is B and E
0
0