Question 510
A dimension uses a mutable email address as the primary join key, so a customer email change breaks facts. Which principle BEST explains why the implementation failed?
Explanation
Correct Answer
Mutable natural attributes are not safe immutable analytical identifiers. This is the most directly relevant technical explanation 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
A metric view defines analytical semantics rather than bypassing source authorization. The controlling issue in this question is that mutable natural attributes are not safe immutable analytical identifiers.
Unreconciled identifiers across layers cause inconsistent joins and counts. Here the important technical distinction is that mutable natural attributes are not safe immutable analytical identifiers.
Delta and Iceberg readers need compatible published table metadata and protocol support. The reported failure instead depends on this fact: mutable natural attributes are not safe immutable analytical identifiers.