COF-C02 · Question #168
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
The correct answer is B. OPERATE. The OPERATE privilege on a virtual warehouse grants a role the ability to start, stop, suspend, and resume the warehouse - i.e., control its operational state. USAGE only allows a role to use the warehouse to execute queries but does not permit changing its running state…
Question
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Options
- AUSAGE
- BOPERATE
- CMONITOR
- DMODIFY
How the community answered
(55 responses)- A2% (1)
- B93% (51)
- C4% (2)
- D2% (1)
Explanation
The OPERATE privilege on a virtual warehouse grants a role the ability to start, stop, suspend, and resume the warehouse - i.e., control its operational state. USAGE only allows a role to use the warehouse to execute queries but does not permit changing its running state. MONITOR allows a role to view warehouse activity and usage statistics. MODIFY allows changing warehouse configuration properties (size, scaling policy, etc.) but does not cover state changes like resuming.
Topics
Community Discussion
No community discussion yet for this question.