You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast
data sourced from a financial database.
The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk spaceand is
doubling in size every month.
The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?
A.
PowerPivot workbook deployed to SharePoint
B.
multidimensional project
C.
tabular project that uses the DirectQuery query mode
D.
tabular project that uses the In-Memory query mode