Snowflake Exam ADA-C01 Topic 1 Question 26 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 26
Topic #: 1

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 Phuong at Sep 14, 2024, 05:37 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Caitlin

7 months ago

This question is so easy, a monkey could answer it. But then again, most of us are probably monkeys in this certification exam anyway.

upvoted 0 times

...

Tasia

7 months ago

Suspend and resume, huh? Sounds like the user needs to be the task master. I'll go with A) and C) for sure.

upvoted 0 times

Edelmira

5 months ago

User 3: A) and C) seem like the right choices for this user's privileges.

upvoted 0 times

...

Dalene

5 months ago

User 2: User should also have C) OPERATE on the task to meet the requirements.

upvoted 0 times

...

Virgina

5 months ago

User 1: I think A) EXECUTE TASK on the task is necessary.

upvoted 0 times

...

Elden

7 months ago

I'm not sure about OWNERSHIP on the task. Would that also be necessary for the user to have the required privileges?

upvoted 0 times

...

Carylon

7 months ago

What? No OWNERSHIP? That's just crazy! How else is the user supposed to modify the task if they need to? I'm going with B) and E).

upvoted 0 times

Elke

6 months ago

No, the user shouldn't be able to modify the task, so EXECUTE TASK is not needed.

upvoted 0 times

...

Willard

6 months ago

But what about EXECUTE TASK? Shouldn't that be included?

upvoted 0 times

...

Sueann

7 months ago

Agreed, those privileges should meet the requirements.

upvoted 0 times

...

Dorcas

7 months ago

I think B) and E) are the way to go.

upvoted 0 times

...

Deandrea

7 months ago

I agree with Tawna. OPERATE on the task allows suspending and resuming the task, while USAGE on the database and schema ensures access without modifying the task.

upvoted 0 times

...

Tawna

8 months ago

I think the user should have OPERATE on the task and USAGE on the database and schema containing the task.

upvoted 0 times

...

Cherri

8 months ago

Hmm, I think the correct answers are A) EXECUTE TASK and C) OPERATE on the task. The user needs to be able to suspend and resume the task, so they need those privileges.

upvoted 0 times

Emmett

7 months ago

Yes, and they also need OPERATE privilege on the task to meet the requirements.

upvoted 0 times

...

Elli

7 months ago

I agree, the user should have EXECUTE TASK privilege to suspend and resume the task.

upvoted 0 times

...