nerdexam
Snowflake

ADA-C01 · Question #18

ADA-C01 Question #18: Real Exam Question with Answer & Explanation

The correct answer is C. OPERATE on the task D. USAGE on the database and schema containing the task. The user needs the OPERATE privilege on the task to suspend and resume it, and the USAGE privilege on the database and schema containing the task to access it. The EXECUTE TASK privilege is not required for suspending and resuming a task, only for triggering a new run. The OWNERS

Question

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run. What privileges should be granted to the user to meet these requirements? (Choose two.)

Options

  • AEXECUTE TASK on the task
  • BOWNERSHIP on the task
  • COPERATE on the task
  • DUSAGE on the database and schema containing the task
  • EOWNERSHIP on the database and schema containing the task

Explanation

The user needs the OPERATE privilege on the task to suspend and resume it, and the USAGE privilege on the database and schema containing the task to access it. The EXECUTE TASK privilege is not required for suspending and resuming a task, only for triggering a new run. The OWNERSHIP privilege on the task or the database and schema would allow the user to modify or drop the task, which is not desired.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full ADA-C01 Practice