How would you execute a series of SQL statements using Task?

How would you execute a series of SQL statements using Task?
A . 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 SELEC
B . . FROM stream .s1 where ..
C . A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask…. AS call stored_prc1(); call stored_proc2t);
D . 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():
E . 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 task 1, task 2 sequentially.

View Answer

Answer: C