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

8 months ago

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

upvoted 0 times

...

Arleen

8 months ago

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

upvoted 0 times

...

Casie

8 months ago

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

upvoted 0 times

...

Virgina

9 months 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

Hubert

7 months ago

D) Creating separate tasks for each SQL statement and sequencing them with a control task is another approach.

upvoted 0 times

...

Germaine

8 months ago

B) Storing the SQL statements in a stored procedure and calling it from the task is a good practice.

upvoted 0 times

...

Tuyet

8 months ago

C) It's more common to use a stored procedure to execute multiple SQL statements in a task.

upvoted 0 times

...

Doretha

8 months ago

A) Yes, option A is a valid way to execute a series of SQL statements using a task.

upvoted 0 times

...

Truman

9 months 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

8 months ago

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

upvoted 0 times

...

Nydia

9 months ago

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

upvoted 0 times

...

Emmanuel

9 months 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

9 months 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

9 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

Arleen

8 months ago

Yes, creating a task to call the stored procedure is a clean way to handle a series of SQL statements.

upvoted 0 times

...

Virgie

8 months ago

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

upvoted 0 times

...

Letha

9 months ago

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

upvoted 0 times

...

Nickie

9 months ago

Option C does seem like the most straightforward approach.

upvoted 0 times

...

Helaine

9 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

9 months ago

User2

upvoted 0 times

...

Lisha

9 months ago

User1

upvoted 0 times

...