Notifications
Clear all
Topic starter
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 SELECT .. FROM stream .s1 where ..
B. 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);
C. 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():
D. 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.
Suggested Answer: C
Posted : 08/02/2023 6:36 pm