Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 359

How would a user execute a series of SQL statements using a task?

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Correct Answer: C

To execute a series of SQL statements using a task, the most efficient way is to create a stored procedure that combines all the necessary SQL statements and then invoke this stored procedure from within the task. This ensures that all statements are executed in sequence as part of a single procedure call, providing better modularity and maintainability. Creating multiple tasks or attempting to use a task with direct SQL statements or sequences of stored procedures invocations is not ideal. Therefore, using a stored procedure with multiple SQL statements inside and invoking it from the task is the correct approach.

Discussion

halolOption: C

C is the answer

fahfouhi94Option: C

C is correct

sailooOption: C

https://community.snowflake.com/s/question/0D53r00009kC6WhCAK/can-a-task-have-multiple-sql-queries C is the answer

_yyuktaOption: C

C is correct

MultiCloudIronManOption: C

correct