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. The reports will show the
relationship between product sales and rainfall over time.
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 and proactive cache

D.
A multidimensional project that uses the ROLAP storage mode and columnstore indexes

E.
A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010