Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
A) independent data marts architecture
B) centralized data warehouse architecture
C) hub-and-spoke data warehouse architecture
D) federated architecture

Question

Quizplus · Accepted Answer

The hub-and-spoke data warehouse architecture uses a normalized relational warehouse as the hub, which feeds multiple data marts as the spokes. This architecture is used to provide a single source of truth and maintain data consistency among the data marts. The independent data marts architecture involves each data mart being constructed separately, without a centralized warehouse. The centralized data warehouse architecture uses a single, centralized warehouse that contains all data, without feeding multiple data marts. The federated architecture uses a combination of multiple independent data sources, with metadata management to provide a unified view of data.

Which Data Warehouse Architecture Uses a Normalized Relational Warehouse That