Question 260
For this Snowflake situation — A security administrator needs to manage role grants without performing unrelated warehouse development work. — the team adopts: Use appropriate security-administration roles and preserve separation from general data engineering roles. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Review administrative delegation and system-role inheritance annually. It controls the recurring exposure associated with this mechanism: Snowflake's system-defined administrative roles divide identity and grant management from ordinary object creation. The original action, use appropriate security-administration roles and preserve separation from general data engineering roles., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: Snowflake role inheritance and active role selection both affect effective access. Here the sustained control must address: Snowflake's system-defined administrative roles divide identity and grant management from ordinary object creation. Choose “Review administrative delegation and system-role inheritance annually”.
That safeguard is relevant to: Snowflake usage views expose warehouse consumption that can be separated from general storage charges. The current failure instead follows from: Snowflake's system-defined administrative roles divide identity and grant management from ordinary object creation. Its prevention measure is “Review administrative delegation and system-role inheritance annually”.
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's system-defined administrative roles divide identity and grant management from ordinary object creation. The matching preventive check is “Review administrative delegation and system-role inheritance annually”.