A data warehouse primarily provides:
2012
A data warehouse primarily provides:
Answer: B. Integrated storage and responsiveness to analytical queries — ConceptA data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data designed to support analysis and managerial…
- A.
Transaction-processing responsiveness
- B.
Integrated storage and responsiveness to analytical queries
- C.
Demand-and-supply responsiveness
- D.
None of these
Attempted by 14 students.
Show answer & explanation
Correct answer: B
Concept
A data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data designed to support analysis and managerial decision-making.
Its workload is mainly read-intensive: it stores consolidated historical data and answers complex analytical queries, while operational transaction systems handle frequent day-to-day inserts and updates.
Application
The capability described by integrated storage and responsiveness to analytical queries matches this analytical role: the warehouse consolidates data and makes it available for querying and reporting.
Contrast
Transaction-processing responsiveness belongs to operational transaction processing rather than the analytical warehouse workload.
Demand-and-supply responsiveness is an operational business or supply-chain concern, not the defining data-management service here.
None of these is excluded because one offered capability directly describes the warehouse role.
Cross-check
Classifying the workload gives the same result: write-heavy, current-transaction processing maps to OLTP, whereas consolidated storage plus complex read queries maps to a data warehouse. Therefore, the answer is integrated storage and responsiveness to analytical queries.
Explore the full course: Mppsc Assistant Professor Computer Science Paper 2