Question 230
Consider this Snowflake situation: A new administrator plans to grant table privileges directly to every employee account as individual permissions. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Snowflake RBAC promotes reusable role grants instead of managing each user privilege separately. It supports the response: Assign object privileges to managed roles and grant those roles to users as appropriate. Confirm it with this observable result: Two test employees with the same approved functional role obtain the same intended table access. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
Multi-factor authentication reduces the risk from a stolen password in interactive access scenarios. That explanation applies to a different technical failure. Here the controlling principle is: Snowflake RBAC promotes reusable role grants instead of managing each user privilege separately.
The offered statement is true for this other mechanism: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case. It does not explain the facts described here, which follow from: Snowflake RBAC promotes reusable role grants instead of managing each user privilege separately.
Warehouse-level credit records make usage-based chargeback possible when ownership is governed. That explanation applies to a different technical failure. Here the controlling principle is: Snowflake RBAC promotes reusable role grants instead of managing each user privilege separately.