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:
Identify atomic facts and dimensions as the authoritative, detailed layer.Define derived artifacts (summary tables, materialized views, semantic models) with lineage back to atomic data.Use governance to certify which derived data sets are “official” for reporting.Maintain refresh schedules so derived values stay timely, but recognize they are not the atomic source.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