Which development approach and mode should you use?

You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort.

Which development approach and mode should you use?
A . Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery.
B . Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery.
C . Develop a multidimensional project and configure the model with the DirectQuery mode setting off.
D . Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode.

View Answer

Answer: C

Explanation:

/ After the upgrade users must be able to perform the following tasks:

/ Ad-hoc analysis of data in the SSAS databases by using the Microsoft Excel PivotTable client (which uses MDX).

/ Daily operational analysis by executing a custom application that uses ADOMD.NET and existing Multidimensional Expressions (MDX) queries.

/ Deploy a data model to allow the ad-hoc analysis of data. The data model must be cached and source data from an OData feed.

We cannot use DirectQuery mode so C is the only answer that will provide the required caching.

When a model is in DirectQuery mode, it can only be queried by using DAX. You cannot use MDX to create queries. This means that you cannot use the Excel Pivot Client, because Excel uses MDX.