Question 220
For this Snowflake situation — An analyst cannot read a reporting table although the correct Snowflake user account successfully logs in. — the team adopts: Grant the necessary database, schema, and table privileges to an approved functional role and assign that role to the user. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Review role and namespace grants when report ownership changes. It controls the recurring exposure associated with this mechanism: Snowflake role-based access control separates authentication from authorization on database objects. The original action, grant the necessary database, schema, and table privileges to an approved functional role and assign that role to the user., still needs operational checks when the environment or workload changes.
Incorrect Answers
This routine guards against another mechanism: Compute permission does not imply permission to see the database objects that compute will query. The recurring exposure in the current case is: Snowflake role-based access control separates authentication from authorization on database objects. The matching preventive check is “Review role and namespace grants when report ownership changes”.
That safeguard is relevant to: Lineage metadata helps document dependencies and provenance across derived data assets. The current failure instead follows from: Snowflake role-based access control separates authentication from authorization on database objects. Its prevention measure is “Review role and namespace grants when report ownership changes”.
This routine guards against another mechanism: Resource monitors can track warehouse credit thresholds and trigger configured responses. The recurring exposure in the current case is: Snowflake role-based access control separates authentication from authorization on database objects. The matching preventive check is “Review role and namespace grants when report ownership changes”.