Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
Data mart architectures can be independent (built directly from operational systems) or dependent (sourced from a conformed enterprise data warehouse). This question probes why independent marts often appear in organizations.
Given Data / Assumptions:
Concept / Approach:
When business priorities are short-term, teams frequently spin up stand-alone marts to meet local KPIs fast. Without conformed dimensions and shared definitions, these marts drift, creating “spreadmarts” and inconsistent metrics across the enterprise. While they can deliver quick wins, they complicate cross-functional analytics later.
Step-by-Step Solution:
Verification / Alternative check:
Compare “Customer” metrics across finance and sales marts. If definitions or totals differ, the organization likely has independent marts created for short-term goals rather than a coordinated enterprise model.
Why Other Options Are Wrong:
Common Pitfalls:
Proliferation of conflicting truth sources, duplicate ETL, and higher maintenance. Establish a roadmap for conformance to regain consistency while preserving agility.
Final Answer:
Correct
Discussion & Comments