Snowflake ADA-C01 Exam - Topic 3 Question 50 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 50
Topic #: 3

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? (Select TWO).

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

Show Suggested Answer

Suggested Answer: C, D

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 it1.The EXECUTE TASK privilege is not required for suspending and resuming a task, only for triggering a new run1. 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.

by Alexis at Apr 05, 2026, 10:26 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Callie

4 days ago

I think D is also important for context.

upvoted 0 times

...

Gregoria

9 days ago

A and C are the right choices!

upvoted 0 times

...

Gertude

1 month ago

I’m a bit confused about the difference between OPERATE and EXECUTE TASK. I hope I remember the right combination for this scenario!

upvoted 0 times

...

Alishia

1 month ago

This question feels familiar; I think we practiced something similar where we had to limit user permissions without giving them ownership.

upvoted 0 times

...

Cristy

1 month ago

I'm not entirely sure, but I remember something about needing USAGE on the database and schema for tasks to work properly.

upvoted 0 times

...

Benedict

2 months ago

I think we need to give the user some level of control over the task, so maybe EXECUTE TASK and OPERATE?

upvoted 0 times

...