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 WarehouseCONCEPT: A data store is classified by what it is designed to retain and how that retained data is used. Operational systems emphasize current transactions,…

  1. A.

    Database

  2. B.

    Data Mining

  3. C.

    Data Warehouse

  4. 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

Loading lesson…