Question 150
A multi-region SQL analytics app must prevent staff from seeing rows assigned to another region. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
Row-Level Security predicates enforce row access in the database based on a validated execution context. Implement a schema-bound security predicate backed by trustworthy identity attributes. Cross-region query tests return no forbidden records for low-privileged users.
Incorrect Answers
Client-side filtering happens after sensitive rows have already left SQL. Enforce regional RLS in the database.
A spoofable region attribute can bypass RLS. Derive row policy from a trustworthy authenticated SQL execution context.
Database ownership defeats least privilege; apply schema-bound RLS and restricted grants to regional staff access.