Question 280
For this Snowflake situation — A regional sales dashboard must show only records belonging to each analyst's allowed territory. — the team adopts: Use a governed row access policy to filter eligible records according to the session's authorization context. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Revalidate territory mapping tables and policy behavior after reorganizations. It controls the recurring exposure associated with this mechanism: Row access policies can enforce per-row visibility independent of a dashboard's client-side filters. The original action, use a governed row access policy to filter eligible records according to the session's authorization context., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: Row-level protection must remain enforced through data migrations and application changes. Here the sustained control must address: Row access policies can enforce per-row visibility independent of a dashboard's client-side filters. Choose “Revalidate territory mapping tables and policy behavior after reorganizations”.
That safeguard is relevant to: Repeated executions may consume additional warehouse compute independently of whether the result is identical. The current failure instead follows from: Row access policies can enforce per-row visibility independent of a dashboard's client-side filters. Its prevention measure is “Revalidate territory mapping tables and policy behavior after reorganizations”.
This routine guards against another mechanism: Snowflake RBAC promotes reusable role grants instead of managing each user privilege separately. The recurring exposure in the current case is: Row access policies can enforce per-row visibility independent of a dashboard's client-side filters. The matching preventive check is “Revalidate territory mapping tables and policy behavior after reorganizations”.