A data warehouse primarily provides:

2012

A data warehouse primarily provides:

Answer: B. Integrated storage and responsiveness to analytical queriesConceptA data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data designed to support analysis and managerial…

  1. A.

    Transaction-processing responsiveness

  2. B.

    Integrated storage and responsiveness to analytical queries

  3. C.

    Demand-and-supply responsiveness

  4. 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: Nta Ugc Net Paper 2

Loading lesson…