SOL-C01 · Question #13
SOL-C01 Question #13: Real Exam Question with Answer & Explanation
The correct answer is B: Use the 'DEFAULT_PRIVILEGES' parameter at the database level to automatically grant the. 'DEFAULT PRIVILEGES is the intended and most efficient mechanism for automatically granting privileges on future objects within schemas. Options A, C, D, and E are more complex and less efficient. Option D requires manual execution each time. Option A requires more overhead. Opti
Question
A Snowflake administrator wants to ensure that all newly created schemas in a specific database automatically inherit certain grants (e.g., 'SELECT' privilege on all tables in the schema to a reporting role). Which of the following approaches is the MOST suitable to accomplish this?
Options
- ACreate a stored procedure that is automatically executed after each 'CREATE SCHEMA'
- BUse the 'DEFAULT_PRIVILEGES' parameter at the database level to automatically grant the
- CImplement a custom event listener that triggers upon schema creation and executes the necessary
- DManually execute GRANT FUTURE GRANTS' statements after each schema creation to grant the
- ESchedule a periodic Snowflake Task to search for recently created schemas and grant needed
Explanation
'DEFAULT PRIVILEGES is the intended and most efficient mechanism for automatically granting privileges on future objects within schemas. Options A, C, D, and E are more complex and less efficient. Option D requires manual execution each time. Option A requires more overhead. Option C is not available in Snowflake. Option E has a delay before new permissions are granted and can be a performance overhead.
Topics
Community Discussion
No community discussion yet for this question.