Implement Streams and Tasks DEA-C02 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A data engineer has a task that runs every 10 minutes and processes a stream. The task has been failing for the past hour due to a syntax error in the SQL. The team wants to fix the error and ensure the task resumes processing without missing any changes that occurred during the failure period. What should they do?

   • ADrop the stream and recreate it, then alter the task to correct the SQL and resume it.
   • BCreate a new task with the corrected SQL and let it run alongside the old task.
   • CDrop the task, recreate it with the corrected SQL, and let it process the stream from the current offset.
   • DAlter the task to correct the SQL, then resume the task. The stream will still contain all changes that arrived during the failure.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What happens to the change data in a stream after a task consumes it?

   • AThe stream is automatically dropped after consumption.
   • BThe data remains in the stream until the source table is dropped.
   • CThe data is automatically deleted from the source table.
   • DThe stream's offset advances, and the consumed changes are no longer available in subsequent reads.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   In a CREATE TASK statement, which parameter specifies the virtual warehouse used to run the task?

   • ARESOURCE_POOL
   • BCOMPUTE
   • CSCHEDULE
   • DWAREHOUSE
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A data engineering team has created a stream on a source table and a task that runs every 5 minutes to merge new changes into a downstream reporting table. After the first successful task run, they notice that the stream no longer returns the rows that were processed. The team wants to ensure that any changes that arrive between task runs are not missed. What should they confirm about the current setup?

   • AThe task is scheduled with a cron expression that runs only once, so the stream offset only advances on the first run.
   • BThe stream is of type APPEND_ONLY, which prevents updates and deletes from being captured, so only inserts are processed.
   • CThe task uses a single SQL statement that performs the merge and the stream offset advances automatically after the task commits.
   • DThe stream was created on a view, and views do not track offsets, so the data is consumed but the offset is not persisted.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following can a Snowflake task execute?

   • AA single SQL statement or a call to a stored procedure
   • BA Snowpipe that loads data from a stage
   • CA Python script that runs in a separate environment
   • DMultiple SQL statements separated by semicolons
   Reveal Solution Discussion Select an answer first