You are developing a BI Semantic Model (BISM) based on a simple and small dataset
sourced from SQL Server. The data size and complexity of the data relationships will not
change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all
that apply.)
A.
A tabular project that uses the In-Memory query mode
B.
A tabular project that uses the DirectQuery query mode
C.
A multidimensional project that uses the MOLAP storage mode
D.
A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
E.
A multidimensional project that uses the ROLAP storage mode
Explanation:
Power View is a thin web client that launches right in the browser from a data model in
SharePoint Server 2010. The model can be a PowerPivot model workbook or a tabular
model running on a SQL Server 2012 Analysis Services (SSAS) server.
Due the explanation, cant be E option, should be D instead.
Since 2012 sp1 cu4 version multidimentional sources is also
available for power view reports on sharepoint (not excel).
So all answers correct.
I think this question had expired or updated.
A B D
Sani is correct!
Sani is right.
The key is that the model is simple with a small dataset. Although powerview for multidimensional is now supported, either type Multidimensional model (MOLAP or ROLAP)is not appropriate as the development time and effort is much longer/harder and best suited to complex situations. You definitely would NOT need multidimensional with ROLAP configured as this is absolute overkill given the small size of the data. Tabular with Direct query is arguably overkill as well but given they didnt specify anything related to latency it is still an acceptable option.
Tabular and PowerPivot offer the fastest and simplest way to develop for this situation.
I agree
I would say A and D
because the data wont change and it is a small set. I don’t see any point in using DirectQuery mode.