Which database design is commonly used in OLAP systems?
2025
Which database design is commonly used in OLAP systems?
- A.
ER-based
- B.
Relational model
- C.
Star/snowflake schema
- D.
Hierarchical model
Attempted by 4 students.
Show answer & explanation
Correct answer: C
OLAP systems utilize dimensional modeling, such as star or snowflake schemas, to optimize analytical queries. These structures separate fact and dimension tables for efficient read operations compared to normalized transactional models.