Snowflake Exam COF-R02 Topic 3 Question 45 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 45
Topic #: 3

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

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

BA 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();

CUse 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();

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

Show Suggested Answer

Suggested Answer: D

by Margurite at Sep 15, 2024, 05:09 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Matthew

9 days ago

I agree with Casie, option A is more efficient in executing a series of SQL statements.

upvoted 0 times

...

Arleen

10 days ago

I prefer option D. Creating a task for each SQL statement seems more organized to me.

upvoted 0 times

...

Casie

11 days ago

I think option A is the way to go. It allows for multiple SQL statements in the task.

upvoted 0 times

...

Virgina

15 days ago

Is option A for real? Embedding SQL statements directly in the task body? That's like trying to write a novel in the margins of a postage stamp.

upvoted 0 times

...

Truman

25 days ago

Option D looks like a lot of work, setting up separate tasks just to run a series of SQL statements. I'd go with option C and let the stored procedure handle the heavy lifting.

upvoted 0 times

Claribel

3 days ago

Yes, it simplifies the process and makes it easier to manage the series of SQL statements within a task.

upvoted 0 times

...

Nydia

15 days ago

I agree, using a stored procedure to execute multiple SQL statements seems more efficient and organized.

upvoted 0 times

...

Emmanuel

16 days ago

Option D looks like a lot of work, setting up separate tasks just to run a series of SQL statements. I'd go with option C and let the stored procedure handle the heavy lifting.

upvoted 0 times

...

Iluminada

28 days ago

Hah, option B is like trying to fit an entire meal into a single bite. Good luck with that one!

upvoted 0 times

...

Winfred

1 months ago

I'm not sure about the other options, but option C seems the most straightforward. Encapsulating the SQL logic in a stored procedure and calling it from the task makes sense.

upvoted 0 times

Virgie

11 days ago

It definitely helps in organizing and managing the SQL logic efficiently.

upvoted 0 times

...

Letha

15 days ago

I agree, using a stored procedure for multiple SQL statements simplifies the task execution.

upvoted 0 times

...

Nickie

19 days ago

Option C does seem like the most straightforward approach.

upvoted 0 times

...

Helaine

1 months ago

Option C looks like the way to go. Using a stored procedure to execute multiple SQL statements in a single task seems like the most efficient approach.

upvoted 0 times

Celestina

17 days ago

User2

upvoted 0 times

...

Lisha

21 days ago

User1

upvoted 0 times

...