Implement Streams and Tasks ARA-C01 Practice Questions (Page 5)

Questions 21–24

1. 21foundation · easy

   What happens to a task's state if its SQL statement fails?

   • AThe task run is marked as failed, and the task continues to run on its schedule
   • BThe task's schedule is permanently disabled
   • CThe task is suspended and requires manual intervention
   • DThe task is automatically dropped
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   When would you choose an append-only stream over a standard stream?

   • AWhen you need to capture the before-image of updated rows
   • BWhen you need to track all changes including updates and deletes
   • CWhen you want to reduce storage costs by not storing any metadata
   • DWhen you only need to process new rows and do not need to handle deletes or updates
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A team needs to track changes to a table that is used for auditing. They need to capture all inserts, updates, and deletes, but they do not want to process the same change twice. Which stream type should they use?

   • AAppend-only stream
   • BStandard stream
   • CChange tracking stream
   • DInsert-only stream
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A team has a complex task DAG with multiple branches. They want to monitor the execution of each task and identify any failures. What should they use to monitor task runs?

   • AThe TASK_DEPENDENCY view in the ACCOUNT_USAGE schema.
   • BThe QUERY_HISTORY view in the ACCOUNT_USAGE schema.
   • CThe TASK_HISTORY view in the ACCOUNT_USAGE schema.
   • DThe STREAMS view in the ACCOUNT_USAGE schema.
   Reveal Solution Discussion Select an answer first