Multiple choice technology

What is derived data?

  1. Data that is reconciled and stored in the data warehouse

  2. Data that is calculated and stored in the data warehouse

  3. Data that is stored in the ODS

  4. Numeric data that is stored in the data warehouse

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Derived data is data that is calculated from other data and stored in the data warehouse. Examples include totals, ratios, percentages, or any computed values. Unlike raw data which is copied directly, derived data involves computation before storage.