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?

Question

Options

• ADevelop a tabular project and configure the model with the DirectQuery mode setting on
• BDevelop a tabular project and configure the model with the DirectQuery mode setting on
• CDevelop a multidimensional project and configure the model with the DirectQuery mode
• DDevelop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP)

• A
  7% (1)
• B
  13% (2)
• C
  53% (8)
• D
  27% (4)

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

No community discussion yet for this question.