In a generic two-level data warehouse architecture, which component is typically included alongside the core warehouse?

Introduction / Context:Two-level architectures commonly refer to a central enterprise warehouse plus one or more dependent data marts. Recognizing this helps understand layering and semantic curation for departments.

Given Data / Assumptions:

• The “two levels” are enterprise DW and downstream data marts/semantic layers.
• Multiple sources are typical of any warehouse, not unique to “two-level.”
• Near real-time updates are optional; the model does not require them.

Concept / Approach:Data marts provide subject-specific, performance-optimized subsets (e.g., finance, sales). They inherit from or are fed by the enterprise warehouse, forming two tiers.

Step-by-Step Solution:

Verification / Alternative check:Reference architectures often depict Enterprise DW → Data Marts → Reports/Analytics.

Why Other Options Are Wrong:Many sources: True in general but not defining of “two-level.” Near real-time: Optional characteristic, not required.

Common Pitfalls:Assuming “two-level” implies streaming or specific latency guarantees.

Final Answer:At least one data mart