Question 850
A regional report should show only EU patients for its local analysts but one shared table exposes all regions. Which continuing control should the team adopt after recovery?
Explanation
Correct Answer
Test row filter policies under role changes. This is the most directly relevant preventive control because a table SELECT grant alone does not constrain individual row visibility. A concrete acceptance check is: Test principals from two regions see only their authorized patient rows. To reduce recurrence: Test row filter policies under role changes.
Incorrect Answers
Incompatible simultaneous mask definitions cannot be arbitrarily resolved at query time. That consideration does not remove the current constraint: a table SELECT grant alone does not constrain individual row visibility.
Separate ingestion code paths can reintroduce cleartext after initial cleanup. In this situation, a table SELECT grant alone does not constrain individual row visibility.
Uncontrolled copies escape table-level access, retention and audit policies. The controlling issue in this question is that a table SELECT grant alone does not constrain individual row visibility.