You are developing a SQL Server 2008 Analysis Server (SSAS) method which includes a
measure group called TestGroup with a one partition for Company.com.
The condition listed below should be included
* Searches which utilize TestGroup on the newest version of the information.
* In a many aspects format, the whole collections which are member of TestGroup are
reserved.
In order to solve the problem, which is the correct answer?
A.
You should configure Real-time hybrid online analytical processing (HOLAP)
B.
You should configure Real-time relational offline analytical processing (ROLAP).
C.
You should configure scheduled relational offline analytical processing (ROLAP).
D.
You should configure scheduled online processing (MOLAP).
Explanation:
HYBRID OLAPAs 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
ROLAP does.
—————————————————————————————————————-
EXAM TIP
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.