SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ22

Manage and maintain database objects and virtual warehouses

An Administrator has a user who must be able to suspend and resume a task according to the current virtual warehouse load, but the user must not be able to modify the task or initiate a new run.

Which privileges should be granted to the user to satisfy these requirements?

Choose two
Explanation

A role with the OPERATE privilege on a Snowflake task can suspend or resume it without becoming the task owner. That role also requires USAGE on the database and schema that contain the task. OWNERSHIP permits task-property changes, while EXECUTE TASK is associated with starting task runs rather than being required for suspension or resumption.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!