Microsoft
70-768 · Question #48
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…
The correct answer is A. a tabular project that uses the DirectQuery query mode B. a tabular project that uses the In-Memory query mode E. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010. See the full explanation below for the reasoning.
Question
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.)
Options
- Aa tabular project that uses the DirectQuery query mode
- Ba tabular project that uses the In-Memory query mode
- Ca multidimensional project that uses the ROLAP storage mode
- Da multidimensional project that uses the MOLAP storage mode
- Ea PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
How the community answered
(30 responses)- A83% (25)
- C10% (3)
- D7% (2)
Community Discussion
No community discussion yet for this question.