Question 730
A multi-tenant healthcare data lake needs to restrict which records each analyst sees. An auditor must prove the outcome of Replace voluntary query filtering with an enforced UC row filter policy for this requirement: A migration incorrectly relies on WHERE conditions added by individual analysts. Which test result is best?
Explanation
Correct Answer
A query without an explicit WHERE clause still returns only permitted rows directly measures whether Replace voluntary query filtering with an enforced UC row filter policy achieved the requirement “A migration incorrectly relies on WHERE conditions added by individual analysts.” It checks the operating result rather than just a configured resource name.
Incorrect Answers
This signal belongs to the adjacent case “An ABAC policy applies to an entire schema but a new table is added,” whose remedy is Tag the new table/columns appropriately under the scoped policy. The observed result for the present requirement is A query without an explicit WHERE clause still returns only permitted rows.
Cross-tenant test rows are excluded according to the intended policy would demonstrate the separate action Fix the row-filter mapping to the authoritative tenant column, which addresses “One table has several different tenant columns and the wrong field was used for enforcement.” It does not verify the requirement “A migration incorrectly relies on WHERE conditions added by individual analysts” following Replace voluntary query filtering with an enforced UC row filter policy.
That observation is a valid indicator for “A verified deletion request targets one customer's personal rows in an active Delta table” when using Apply a scoped transactional DELETE or supported erasure operation. The scenario instead tests “A migration incorrectly relies on WHERE conditions added by individual analysts”; the relevant result is A query without an explicit WHERE clause still returns only permitted rows.