Question 300
While validating a Snowflake workload, engineers observe: An application engineer tries to grant SELECT on a table in a managed access schema but is not the schema owner or a qualified grant administrator. What should the team change first?
Explanation
Correct Answer
The root issue is that grant control in a managed access schema is centralized rather than always delegated to object owners. The selected fix targets that condition: Request the intended grant from the authorized schema owner or grant administrator. Validate it by checking this outcome: The selected role gains read access through an approved grant without bypassing schema governance.
Incorrect Answers
This action targets system administration separation, where broad system administrator privileges exceed the developers' operational duties. In the given incident, the decisive issue is instead that grant control in a managed access schema is centralized rather than always delegated to object owners.
This action targets role based access grant, where the active role does not have the required database and table privileges. The corrective response here is “Request the intended grant from the authorized schema owner or grant administrator”; this alternative does not provide that response.
This action targets secondary roles in sessions, where Snowflake can evaluate enabled secondary roles as well as the current primary role for authorized operations. The stem reports an application engineer tries to grant SELECT on a table in a managed access schema but is not the schema owner or a qualified grant administrator; this control addresses a different failure condition.