Question 10
A dimension uses a mutable email address as the primary join key, so a customer email change breaks facts. Which change most directly addresses the operational problem?
Explanation
Correct Answer
Use a stable surrogate dimension key and maintain business-key mapping. This is the most directly relevant remediation because mutable natural attributes are not safe immutable analytical identifiers. A concrete acceptance check is: Old and new email records resolve to the intended customer entity. To reduce recurrence: Review dimension key stability during source migrations.
Incorrect Answers
Governed metrics still depend on valid source columns and relationships. That consideration does not remove the current constraint: mutable natural attributes are not safe immutable analytical identifiers.
Cross-format readers rely on maintained snapshot metadata to observe current data. In this situation, mutable natural attributes are not safe immutable analytical identifiers.
Unreconciled identifiers across layers cause inconsistent joins and counts. For the observed behavior, mutable natural attributes are not safe immutable analytical identifiers.