D. The role must have access to the target schema and the CREATE TASK privilege on the schema itself: The role executing the CREATE TASK statement must have access privileges on the schema where the task will be created. This includes having the necessary privileges to create objects within the schema. Typically, the role needs the CREATE TASK privilege granted on the specific schema.

Only CREATE TASK at the schema level is required, not global. 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 same schema.

Only CREATE TASK at the schema level is required, not global: https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Was on exam Dec 31st, 2022

correct answer:D

D. The role must have access to the target schema and the CREATE TASK privilege on the schema itself. In Snowflake, to create a task, the role must have access to the target schema where the task will be created, and it needs the CREATE TASK privilege on that schema. This ensures that users can only create tasks in schemas where they have been granted the necessary permissions

Ans is D Global Privileges dont have CREATE TASK in it CREATE TASK is present in Schema level privileges only Doc: https://docs.snowflake.com/en/user-guide/security-access-control-privileges

A is correct

D is correct

D is answer

Ans - D

D is correct