Difficulty: Easy
Correct Answer: Current data intended to be the single source for all decision support systems.
Explanation:
Introduction / Context:
Reconciled data sits at the heart of an enterprise data warehouse. It is the “single version of the truth,” integrated from multiple sources and structured to drive consistent analytics across departments.
Given Data / Assumptions:
Concept / Approach:
Reconciled data is the enterprise-integrated, current-level data that serves as the authoritative input for BI/analytics. It differs from raw operational data (still siloed) and from presentation-layer data (curated/aggregated for end users).
Step-by-Step Solution:
Verification / Alternative check:
Most DW reference architectures (hub-and-spoke or centralized EDW) place reconciled/conformed data before marts.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing “current” with “transactional”; reconciled stores may also keep limited history, but the key is integration and conformance.
Final Answer:
Current data intended to be the single source for all decision support systems.
Discussion & Comments