70-467 Free Dumps Study Materials
Question 11: 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 multidimensional project and configure the model with the DirectQuery mode setting
off.
B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the
project query mode set to DirectQuery.
C. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage
mode.
D. 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.
Correct Answer: A
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.