Multiple choice technology

Data model in a Data warehouse is

  1. Generally dimensionally modelled and tuned to optimise query performance

  2. Generally modelled to support rapid data update

  3. Should not be in Dimensional Modelling way

  4. None
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data warehouses use dimensional modeling (star schema, snowflake schema) to optimize query performance for analytical workloads, unlike transactional systems designed for rapid updates. Dimensional modeling organizes data into fact tables (measurements) and dimension tables (descriptive attributes) for efficient multi-dimensional analysis.

Keep practicing — related questions