What privileges are required to create a task?

The correct answer is D. The role must have access to the target schema and the create task privilege on the schema itself. All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Snowflake Account and Security

Question

Options

AThe global privilege create task is required to create a new task.
BTasks are created at the Application level and can only be created by the Account Admin role.
CMany Snowflake DDLs are metadata operations only, and create task DDL can be executed
DThe role must have access to the target schema and the create task privilege on the schema itself.

How the community answered

(23 responses)

A
9% (2)
B
4% (1)
C
13% (3)
D
74% (17)

Explanation

All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Topics

#tasks#CREATE TASK#schema privileges#access control

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice