COF-C02 Question #583: Real Exam Question with Answer & Explanation

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 abort

Account Access and Security

Question

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

Options

AUSAGE
BOPERATE
CMODIFY
DMONITOR

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 Browse All COF-C02 Questions