70-448 · Question #40
70-448 Question #40: Real Exam Question with Answer & Explanation
The correct answer is A. You should configure Real-time hybrid online analytical processing (HOLAP). As its name suggests, HOLAP is a hybrid between MOLAP and ROLAP. In HOLAP, the cube data remains in the relational store, but the aggregations are stored on the SSAS server. HOLAP is the most effi cient mode in terms of disk space because detail-level data is not duplicated, as i
Question
Options
- AYou should configure Real-time hybrid online analytical processing (HOLAP)
- BYou should configure Real-time relational offline analytical processing (ROLAP).
- CYou should configure scheduled relational offline analytical processing (ROLAP).
- DYou should configure scheduled online processing (MOLAP).
Explanation
As its name suggests, HOLAP is a hybrid between MOLAP and ROLAP. In HOLAP, the cube data remains in the relational store, but the aggregations are stored on the SSAS server. HOLAP is the most effi cient mode in terms of disk space because detail-level data is not duplicated, as it is with MOLAP, and HOLAP requires less space to store aggregations than Choose the HOLAP storage mode if you want to store cube aggregations on the SSAS server but keep the fact data in the source database. In terms of query performance, HOLAP scores in the middle. If the query can be satisfi ed entirely by existing aggregations, HOLAP performs as well as MOLAP. But if it cannot be satisfied, the query is sent to the relational database, and performance suffers. In terms of processing times, HOLAP cubes might be processed faster than either MOLAP or ROLAP cubes because data is read only once to create aggregations. However, because SSAS has an efficient storage architecture, in real life MOLAP and HOLAP should give you comparable processing times, so it is best to consider HOLAP only for large historical partitions that are queried infrequently.
Community Discussion
No community discussion yet for this question.