Question 50
A team maintains separate bronze, silver and gold copies but never defines which layer owns the customer business key. Which implementation choice BEST addresses the stated failure?
Explanation
Correct Answer
Establish canonical keys and conformed definitions in silver before downstream dimensional modeling. This is the most directly relevant remediation 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
Governed metrics still depend on valid source columns and relationships. Here the important technical distinction is that unreconciled identifiers across layers cause inconsistent joins and counts.
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.
Independent transaction protocols cannot be treated as one shared commit log. In this situation, unreconciled identifiers across layers cause inconsistent joins and counts.