Which database design is commonly used in OLAP systems?
2025
Which database design is commonly used in OLAP systems?
Answer: C. Star/snowflake schema — OLAP systems utilize dimensional modeling, such as star or snowflake schemas, to optimize analytical queries. These structures separate fact and dimension…
- A.
ER-based
- B.
Relational model
- C.
Star/snowflake schema
- D.
Hierarchical model
Attempted by 17 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.
Loading lesson…