Within business intelligence and analytics, what type of operational data does a data warehouse primarily store for analysis and reporting over time?
-
Apartial operational data.
-
Bhistorical operational data.
-
Cfuture operational data.
-
Dhealth care data.
Answer
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:
- Operational systems capture day-to-day transactions.
- Warehouses integrate and persist data snapshots across time for analysis.
- The focus is on past and present data, not hypothetical future records.
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.