Which project type should you choose?

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 space and 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?

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 space and 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.
Tabular project that uses the In-Memory query mode

B.
PowerPivot workbook deployed to SharePoint

C.
Tabular project that uses the DirectQuery query mode

D.
Multidimensional project



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Ralph

Ralph

Multidimensional solution is the best for big projects. Here we have a big solution, so D is correct

Youri

Youri

I would opt for D, because of the rapid size of its growth

Henk Schenkworst

Henk Schenkworst

D