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

Questions 16–20

1. 16expert · easy

   A team has a stream on a table and a task that runs every 10 minutes. The task processes the stream and then performs additional transformations. The team wants to ensure that if the task fails, the changes are not lost and can be reprocessed. What should they do?

   • AUse a standard stream and rely on the task to retry on failure.
   • BCreate a second stream on the same table to capture changes in parallel.
   • CUse a timestamp-based stream to query historical changes.
   • DUse an append-only stream to ensure changes are not lost.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is the typical pattern for using a stream and a task together in a continuous data pipeline?

   • AA stream automatically triggers a task when new data arrives
   • BA stream is used to load data into a table, and a task is used to query the stream
   • CA task creates a stream on a table and then deletes it after processing
   • DA task reads from a stream on a schedule and processes the new changes
   Reveal Solution Discussion Select an answer first
4. 18expert · medium

   A team has a stream on a source table and a task that runs every 5 minutes. The task processes the stream and merges changes into a downstream table. Recently, the task has been taking longer than 5 minutes to complete, and the team is concerned about missing changes. What is the best approach to ensure no changes are missed?

   • AUse a larger warehouse to speed up the task execution.
   • BIncrease the task frequency to every 1 minute to process changes more frequently.
   • CKeep the task frequency at 5 minutes and ensure the task processes all changes in the stream in a single run.
   • DCreate a second task to process the stream in parallel.
   Reveal Solution Discussion Select an answer first
5. 19application · easy

   A data engineer has a task that runs every hour and processes a stream. The task has been failing for the past 3 hours due to a bug in the SQL. The team has fixed the bug and wants to resume the task. They are concerned about the changes that accumulated during the failure. What should they do?

   • ADrop the stream and recreate it to clear the accumulated changes.
   • BManually insert the changes into the downstream table before resuming the task.
   • CCreate a new task and let it process the stream from the beginning.
   • DResume the task — the stream will contain all changes that arrived during the failure.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   How can you optimize the cost of a task that processes a stream?

   • AAvoid using streams and tasks altogether
   • BUse a larger warehouse to process data faster
   • CRun the task less frequently and use a smaller warehouse
   • DRun the task continuously without a schedule
   Reveal Solution Discussion Select an answer first