Multiple choice technology

In general, data in data warehousing

  1. normalised

  2. denormalised

  3. none of the above

  4. all the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data warehouses use neither purely normalized nor purely denormalized schemas. They employ dimensional modeling (star/snowflake schemas) which selectively denormalizes dimensions for query performance while maintaining some normalization in fact tables. Different schemas serve different purposes: dimensional modeling is the standard.

Keep practicing — related questions