A.
The GLOBAL privilege CREATE TASK is required to create a new task.
B.
Tasks are created at the Application level and can only be created by the Account Admin role.
C.
Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants.
D.
The role must have access to the target schema and the CREATE TASK privilege on the schema itself.
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.
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
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
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
shubtred
Highly Voted 1 year, 5 months agopranalig
Most Recent 5 months agoPrashantGupta1616
5 months, 2 weeks agokrishnak2244
1 year, 5 months agoMayuri917233
1 year, 6 months agoSV1122
1 year, 10 months agojw1806
1 year, 8 months agoTapasgup007
1 year, 11 months agobharathmv
2 years, 2 months agoarunshai
2 years, 9 months agoSid460545
2 years, 9 months agoarpit_dataguy
2 years, 9 months agoredsky0
2 years, 10 months ago