Multiple choice technology

Which statement of the following is true

  1. Data Mart & DWH both are normalized and can exist in same tier

  2. Data Mart is normalized but DWH is not and they cannot exist in same tier.

  3. DWH is normalized but Data Mart is not and they can exist in same tier.

  4. Both Data Mart & DWH are denormalized and can exist in same tier.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data warehouses and data marts both use denormalized schemas to optimize query performance. Denormalization reduces joins and improves read speed, which is essential for analytical processing. Both can exist in the same tier of an architecture (e.g., an ODS feeding both a DW and multiple marts). Option D correctly states this.

Keep practicing — related questions