Which architecture involves having multiple data marts sourcing from a central data warehouse?
- Data Lake Architecture
- Federated Data Warehouse
- Hub-and-Spoke Architecture
- Star Schema
The architecture that involves having multiple data marts sourcing from a central data warehouse is known as the Hub-and-Spoke architecture. In this setup, the central data warehouse serves as the primary repository, while data marts are created for specific business units or departments, allowing for a balance between centralized control and department-specific needs.
Loading...
Related Quiz
- When a change in a dimension attribute results in marking the old record as inactive and inserting a new record with the changed data, it represents SCD type _______.
- In the context of data warehousing evolution, the shift from batch processing to real-time processing was a significant step towards _______.
- Which type of Slowly Changing Dimension (SCD) uses a separate table to store both current and historical data for an attribute?
- The process of ensuring that data is consistent, reliable, and usable during the ETL process is known as data _______.
- In IT risk management, a(n) _______ is an unforeseen event that can have negative consequences for an organization's objectives.