Which of the following is an analytical repository that integrates data from…
2026
Which of the following is an analytical repository that integrates data from transactional systems and preserves historical data for analysis?
Answer: C. Data Warehouse — CONCEPT: A data store is classified by what it is designed to retain and how that retained data is used. Operational systems emphasize current transactions,…
- A.
Database
- B.
Data Mining
- C.
Data Warehouse
- D.
Big Data
Attempted by 5 students.
Show answer & explanation
Correct answer: C
CONCEPT: A data store is classified by what it is designed to retain and how that retained data is used. Operational systems emphasize current transactions, whereas analytical repositories integrate data over time for reporting and analysis.
A data warehouse is subject-oriented, integrated, time-variant, and non-volatile. Its time-variant property provides historical depth, while integration brings together data generated by transactional systems.
APPLICATION
The wording asks for an analytical repository that combines historical depth with data originating from transactions. Among the offered terms, a data warehouse is designed for that combined analytical view.
CONTRAST
Database: a database is a broad, organized collection of data whose design may support operational or analytical workloads.
Data Mining: data mining applies algorithms to existing datasets to discover patterns, correlations, or predictive rules.
Data Warehouse: a data warehouse integrates data from multiple operational sources into a time-variant, analysis-oriented repository.
Big Data: big data describes datasets and processing architectures characterized by volume, velocity, and variety; storage can involve multiple systems.
RESULT
Therefore, the required analytical repository is a Data Warehouse.
Explore the full course: Mppsc Assistant Professor Computer Science Paper 2