PrepAway - Latest Free Exam Questions & Answers

Which project types should you use?

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.)

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply