Multiple choice technology

Which of the statements are not true about MOLAP architecture

  1. Processing overhead for large input data sets is high

  2. The no of dimensions is usually restricted to 10 or less

  3. Scalability is good

  4. It has a good user interface and functionality

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MOLAP (Multidimensional OLAP) uses pre-computed cubes for fast query performance. However, scalability is POOR, not good. MOLAP struggles with large datasets because cubes require extensive pre-computation and storage. Processing overhead for large datasets is high because all aggregations must be pre-calculated. Dimensions are often restricted (commonly to 10 or fewer) due to cube explosion. User interface is good because pre-computed results enable instant responses. Option C is actually NOT true about MOLAP - it's the limitation.