Snowflake
COF-R02 · Question #298
COF-R02 Question #298: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #298. The question stem and answer options stay visible for context.
Question
How would a user execute a series of SQL statements using a task?
Options
- AInclude the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO
- BA stored procedure can have only one DML statement per stored procedure invocation and
- CUse a stored procedure executing multiple SQL statements and invoke the stored procedure from
- DCreate a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.