COF-C02 · Question #591
Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
The correct answer is A. MODIFY, MONITOR and OPERATE privileges. The global MANAGE WAREHOUSES privilege grants a role the ability to manage all virtual warehouses in an account. According to Snowflake documentation, this is functionally equivalent to granting the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses. MODIFY…
Question
Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
Options
- AMODIFY, MONITOR and OPERATE privileges
- Bownership and usage privileges
- CAPPLYBUDGET and audit privileges
- DMANAGE LISTING ADTOTOLFillment and resolve all privileges
How the community answered
(56 responses)- A95% (53)
- B2% (1)
- C4% (2)
Explanation
The global MANAGE WAREHOUSES privilege grants a role the ability to manage all virtual warehouses in an account. According to Snowflake documentation, this is functionally equivalent to granting the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses. MODIFY allows changing warehouse properties, MONITOR allows viewing warehouse usage and metrics, and OPERATE allows starting/stopping/resuming warehouses. Option B (ownership and usage) is a different set of privileges. Option C (APPLYBUDGET and audit) relates to cost management and auditing, not warehouse management. Option D contains invalid privilege names.
Topics
Community Discussion
No community discussion yet for this question.