PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2024 paper

Module 1: Data Warehousing and Business Analysis

20242m

Which of the following is NOT a type of OLAP system?

(i) MOLAP
(ii) DOLAP
(iii) ROLAP
(iv) HOLAP

Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (ii) DOLAP

The three standard implementations of OLAP are MOLAP (multidimensional storage — data held in specialised cube structures), ROLAP (relational storage — OLAP operations pushed down to SQL on relational tables) and HOLAP (hybrid — MOLAP for aggregated data plus ROLAP for detail data). 'DOLAP' is not part of this standard classification of OLAP architectures.

MOLAP, ROLAP and HOLAP are precisely the trio listed in every textbook, so each of them is a genuine OLAP type. In a 'NOT a type' question the odd one out must therefore be DOLAP.

Similar questions

Data MiningDifferentiate among OLAP, MOLAP and HOLAP.20217mData MiningIn data warehouse technology explain ROLAP, MOLAP and HOLAP techniques of implementing a multidimensional view.20235mData MiningWith neat diagram, explain the architecture of data warehouse. Explain the terms ROLAP, MOLAP and HOLAP.20207mData MiningWhich of the following is NOT a component of a data warehouse? (i) Metadata (ii) ETL tools (iii) OLAP (iv) Web server20242m
PreviousWhich schema is most commonly used in a data warehouse? (i) Star schema (ii) Snowflake schema (iii) Network schema (iv) Tree schemaNextA data warehouse is usually subject-oriented. This means it focuses on: (i) Individual transactions (ii) A specific business area (iii) Real-time data (iv) Day-to-day operations
Official AppAndroid App

PYQDeck for Android

Solve BEU previous-year exam papers anywhere, anytime. Fast search, offline paper viewing, and step-by-step solutions designed specifically for your phone.

Get on Google Play