Difficulty: Easy
Correct Answer: Incorrect
Explanation:
Introduction / Context:
Derived data are created by transforming base (atomic) data: aggregations, calculations, rollups, and other summaries that support analytics. This statement incorrectly equates derived data with the “single authoritative source” of detailed, current data—roles more typically associated with an operational data store (ODS) or mastered operational layer.
Given Data / Assumptions:
Concept / Approach:
Decision support relies on both detailed and derived layers. The authoritative source of truth for operational attributes is usually mastered atomic data; derived layers accelerate analytics by precomputing metrics like daily revenue, 30-day rolling averages, or cohort retention. Conflating these layers leads to confusion and may degrade traceability.
Step-by-Step Solution:
Verification / Alternative check:
Data catalogs typically distinguish “golden” atomic datasets from “certified” derived datasets, with lineage diagrams confirming dependency.
Why Other Options Are Wrong:
Common Pitfalls:
Treating derived metrics as interchangeable with base facts; losing lineage; double-deriving metrics leading to reconciliation issues.
Final Answer:
Incorrect
Discussion & Comments