Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam ADA-C01 Topic 1 Question 26 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 26
Topic #: 1
[All ADA-C01 Questions]

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).

Show Suggested Answer Hide 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
10 days 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
11 days 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
...
Elden
21 days 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
28 days 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
Sueann
9 days ago
User2: Agreed, those privileges should meet the requirements.
upvoted 0 times
...
Dorcas
19 days ago
User1: I think B) and E) are the way to go.
upvoted 0 times
...
...
Deandrea
1 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
1 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
1 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
26 days ago
Yes, and they also need OPERATE privilege on the task to meet the requirements.
upvoted 0 times
...
Elli
30 days ago
I agree, the user should have EXECUTE TASK privilege to suspend and resume the task.
upvoted 0 times
...
...

Save Cancel