Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
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 federated architecture uses metadata from existing data warehouses to create a virtual or hybrid logical data warehouse comprised of data from the other warehouses, without physically integrating the data. This allows for a more flexible and scalable approach to data integration, as it allows for the inclusion of new sources without the need for extensive ETL processes. The other options (independent data marts architecture, centralized data warehouse architecture, and hub-and-spoke data warehouse architecture) do not utilize metadata from existing data warehouses in this way.

Which Data Warehouse Architecture Uses Metadata from Existing Data Warehouses