Answer-first summary for fast verification
Answer: The role must have access to the target schema and the CREATE TASK privilege on the schema itself.
The correct answer is D because creating a task in Snowflake requires the CREATE TASK privilege at the schema level, not globally, and the role must have access to the target schema. Option A is incorrect as there is no global CREATE TASK privilege; CREATE TASK is a schema-level privilege. Option B is incorrect because tasks are not created at the Application level and can be created by roles other than Account Admin, provided they have the necessary schema-level privileges. Option C is misleading; while many DDLs are metadata operations, CREATE TASK does not require a virtual warehouse, but it does require specific grants (the CREATE TASK privilege on the schema), so stating it can be executed without task-specific grants is false. The community discussion, with multiple upvoted comments and references to Snowflake documentation, strongly supports D as the correct answer, emphasizing that CREATE TASK is a schema-level privilege and global privileges do not include it.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What privileges are required to create a task in Snowflake?
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.
No comments yet.