Which privilege is required on a virtual warehouse to abort any existing executing queries?

The correct answer is B. OPERATE. The privilege required on a virtual warehouse to abort any existing executing queries is OPERATE. The OPERATE privilege on a virtual warehouse allows a user to perform operational tasks on the warehouse, including starting, stopping, and restarting the warehouse, as well as…

Account Access and Security

Question

Options

AUSAGE
BOPERATE
CMODIFY
DMONITOR

How the community answered

(36 responses)

A
3% (1)
B
92% (33)
C
6% (2)

Explanation

The privilege required on a virtual warehouse to abort any existing executing queries is OPERATE. The OPERATE privilege on a virtual warehouse allows a user to perform operational tasks on the warehouse, including starting, stopping, and restarting the warehouse, as well as aborting running queries. This level of control is essential for managing resource utilization and ensuring that the virtual warehouse operates efficiently.

Topics

#Warehouse privileges#Query management#Virtual warehouse management#RBAC

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice