COF-C02 Question 309

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B1

  A Task in Snowflake is designed to execute a single SQL statement (could be a COPY INTO, a MERGE, a CALL to a stored procedure, etc.) on a defined schedule or dependency tree. If you need to run multiple SQL statements, you must wrap them inside a stored procedure and then schedule the task to CALL it. Tasks cannot be triggered by SELECT or CALL directly; they’re scheduled.

• Chose C1

  https://docs.snowflake.com/en/sql-reference/sql/create-task As per the snowflake documentation, multiple SQL statments can be executed in a task through SNOWSQL by setting up a delimiter

• 1

  B is correct answer