Which cube design provides the greatest flexibility for Vertical Extensibility?

• A. Specialty Cube
• B. Super Cube
• C. Exclusive Cube
• D. Monolithic Cube

Answer: (B)

Vertical extensibility is the ability to grow a cube by adding new dimensions, measures, and data sources without reworking the existing model. The design built for broad, flexible growth is a Super Cube, because it is created to be generic and scalable. It uses modular components and centralized metadata, so you can plug in new dimensions, hierarchies, or calculations and expand functionality without disrupting current reports or requiring a full redesign. This makes it the best fit when you anticipate future needs across different teams or processes.

A Specialty Cube is tightly tailored to a specific use case, making it harder to extend with new dimensions or data sources. An Exclusive Cube is restricted to a particular domain or group, limiting cross-functional expansion. A Monolithic Cube is large and tightly coupled, which makes changes risky and less feasible as requirements evolve.