Question 580
A solution was implemented for this need: A regional access policy derives the permitted sales territory from each viewer's login ID. The selected approach was: Use a dynamic RLS mapping table with a supported identity function such as USERPRINCIPALNAME() and validated relationships. Which result most directly proves it worked?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Dynamic RLS maps viewer identity to permitted rows with a tested relationship path. A failed implementation may show: Hard-coding one manager's email into every role cannot scale to dynamic viewer access.
Incorrect Answers
External authorized viewers find the three approved items, with drafts unavailable. However, this does not establish the required outcome: two test users receive different permitted territories using the same report.
A restricted user still sees only their authorized region through a new downstream report. However, this does not establish the required outcome: two test users receive different permitted territories using the same report.
Authors can manage finance items within the workspace without controlling unrelated departments. However, this does not establish the required outcome: two test users receive different permitted territories using the same report.