Difficulty: Easy
Correct Answer: historical operational data.
Explanation:
Introduction / Context:
A data warehouse is optimized for analytics, trend analysis, and decision support. It aggregates, cleanses, and structures data over long periods, enabling time-series insights that operational systems are not designed to provide.
Given Data / Assumptions:
Concept / Approach:
Data warehouses store historical operational data extracted via ETL/ELT. Schemas (star/snowflake) support fast queries. Slowly changing dimensions capture attribute history for accurate historical reporting.
Step-by-Step Solution:
Verification / Alternative check:
Kimball and Inmon methodologies both emphasize historical, integrated, subject-oriented data stored for analysis.
Why Other Options Are Wrong:
Partial operational data is too vague.
Future data is speculative and not stored operationally.
Health care data is a domain, not a defining characteristic.
Common Pitfalls:
Confusing a data warehouse with an operational data store (ODS). An ODS may hold more current, integrated data; a warehouse emphasizes historical depth.
Final Answer:
historical operational data.
Discussion & Comments