Data warehouse contains _____ data that is never found in operational…
2018
Data warehouse contains _____ data that is never found in operational environment.
- A.
Summary
- B.
Encoded
- C.
Encrypted
- D.
Scripted
Attempted by 56 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.