Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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 10 months, 1 week agokrishnak2244
Most Recent 10 months, 3 weeks agoMayuri917233
11 months, 2 weeks agoSV1122
1 year, 3 months agojw1806
1 year, 1 month agoTapasgup007
1 year, 4 months agobharathmv
1 year, 7 months agoarunshai
2 years, 2 months agoSid460545
2 years, 2 months agoarpit_dataguy
2 years, 2 months agoredsky0
2 years, 3 months ago