nerdexam
Snowflake

COF-C02 · Question #306

Which task privilege does a Snowflake role need in order to suspend or resume a task?

The correct answer is B. OPERATE. To suspend or resume a Snowflake Task, a role needs the OPERATE privilege on that task. MONITOR allows a role to view the task's details and history but not change its state. USAGE is not a valid privilege for tasks. OWNERSHIP grants full control (including the ability to…

Account Access and Security

Question

Which task privilege does a Snowflake role need in order to suspend or resume a task?

Options

  • AUSAGE
  • BOPERATE
  • CMONITOR
  • DOWNERSHIP

How the community answered

(21 responses)
  • B
    95% (20)
  • D
    5% (1)

Explanation

To suspend or resume a Snowflake Task, a role needs the OPERATE privilege on that task. MONITOR allows a role to view the task's details and history but not change its state. USAGE is not a valid privilege for tasks. OWNERSHIP grants full control (including the ability to operate), but OPERATE is the minimum required privilege specifically for suspending/resuming. When creating a task hierarchy, child tasks also require the OPERATE privilege to be managed.

Topics

#Task management#Privileges#Access control#OPERATE privilege

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice