SnowPro Core Certification — Question 55

What privileges are required to create a task?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because to create a task in Snowflake, a role must have both access to the target schema and the specific CREATE TASK privilege on that schema. Option A is incorrect as the GLOBAL privilege is not required, while option B is wrong because tasks are not limited to the Application level. Option C is also incorrect as it misrepresents the requirements for executing CREATE TASK.