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:
Identify the warehouse’s purpose: long-term analytics.Match that purpose with “historical operational data.”Reject options that imply future or domain-specific data types.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