Question 550
A team maintains separate bronze, silver and gold copies but never defines which layer owns the customer business key. Which explanation most accurately describes the failure mode?
Explanation
Correct Answer
Unreconciled identifiers across layers cause inconsistent joins and counts. This is the most directly relevant technical explanation because unreconciled identifiers across layers cause inconsistent joins and counts. A concrete acceptance check is: The same customer reconciles across clean silver and gold facts. To reduce recurrence: Govern key definitions and identifier lineage.
Incorrect Answers
Different fact table grains create fanout when joined naively. That consideration does not remove the current constraint: unreconciled identifiers across layers cause inconsistent joins and counts.
Repeated custom KPI expressions diverge without one approved metric contract. For the observed behavior, unreconciled identifiers across layers cause inconsistent joins and counts.
Delta and Iceberg readers need compatible published table metadata and protocol support. The controlling issue in this question is that unreconciled identifiers across layers cause inconsistent joins and counts.