Question 80
For this Snowflake situation — A service account with USAGE on a database cannot SELECT a table inside one of its schemas. — the team adopts: Grant only the required schema USAGE and table SELECT privileges to an authorized role. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Revalidate parent and object grants when schemas are reorganized. It controls the recurring exposure associated with this mechanism: Access to a table normally requires the appropriate parent namespace usage plus object-level privileges. The original action, grant only the required schema USAGE and table SELECT privileges to an authorized role., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: Virtual warehouses provide compute; tables are owned as database/schema objects. Here the sustained control must address: Access to a table normally requires the appropriate parent namespace usage plus object-level privileges. Choose “Revalidate parent and object grants when schemas are reorganized”.
That safeguard is relevant to: A larger warehouse can provide more compute and memory to a single demanding query. The current failure instead follows from: Access to a table normally requires the appropriate parent namespace usage plus object-level privileges. Its prevention measure is “Revalidate parent and object grants when schemas are reorganized”.
The suggested review tracks a different technical risk: Compute isolation allows distinct throughput, latency, and spending controls over shared data. Here the sustained control must address: Access to a table normally requires the appropriate parent namespace usage plus object-level privileges. Choose “Revalidate parent and object grants when schemas are reorganized”.