In a Data Analytics pipeline, which of the following is

Solution

Dimensional Modelling simplifies data analysis by structuring data into fact and dimension tables. This star or snowflake schema allows for easier and faster querying, particularly for OLAP systems, by optimizing data retrieval. Why Other Options are Wrong: a) Dimensional modeling is not focused on normalization, which is a feature of relational modeling. b) Transaction processing is more efficient in normalized databases, not dimensional ones. d) Dimensional models may introduce some data redundancy due to denormalization. e) Dimensional modeling is designed for analytical queries, not real-time data processing.