Data warehouse contains _____ data that is never found in operational…

2018

Data warehouse contains _____ data that is never found in operational environment.

Answer: A. SummaryCorrect answer: Summary What summary data means: aggregated or derived records created for reporting and analysis, such as daily sales totals or monthly…

  1. A.

    Summary

  2. B.

    Encoded

  3. C.

    Encrypted

  4. D.

    Scripted

Attempted by 82 students.

Show answer & explanation

Correct answer: A

Correct answer: Summary

  • What summary data means: aggregated or derived records created for reporting and analysis, such as daily sales totals or monthly averages.

  • Why it is not found in operational systems: operational environments store detailed transactional data for day-to-day processing, whereas summary data is produced (aggregated or pre-computed) in the warehouse to speed queries and preserve historical snapshots.

  • Examples: aggregated sales by region, monthly customer cohort metrics, and historical snapshots are typical kinds of summary data in a data warehouse.

  • Why the other choices are incorrect: encoded and encrypted describe representation or security characteristics (not warehouse-only data types), and scripted refers to processes or code rather than a data category.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Mppsc Assistant Professor Computer Science Paper 2

Loading lesson…