Question 220
A privacy deletion removes a customer from silver but the unfiltered bronze raw event remains indefinitely. How should the team correct this issue while preserving the required data contract?
Explanation
Correct Answer
Apply the retention/erasure policy across upstream bronze and downstream derivative datasets. This is the most directly relevant remediation because deleting one modeled table does not erase copies in other pipeline stages. A concrete acceptance check is: A lineage-based search finds the subject absent from all in-scope retained datasets. To reduce recurrence: Maintain an inventory of downstream personal-data copies.
Incorrect Answers
Row access does not imply permission to see every sensitive field in raw form. In this situation, deleting one modeled table does not erase copies in other pipeline stages.
Incompatible simultaneous mask definitions cannot be arbitrarily resolved at query time. For the observed behavior, deleting one modeled table does not erase copies in other pipeline stages.
Predictable low-entropy identifiers may be recovered by dictionary attacks. The controlling issue in this question is that deleting one modeled table does not erase copies in other pipeline stages.