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

Questions 16–20

1. 16application · medium

   A team needs to track only new rows added to a table, not updates or deletes, to feed a real-time dashboard. They want to minimize overhead and avoid processing changes that are not relevant. Which stream type should they use?

   • AAppend-only stream
   • BStandard stream
   • CInsert-only stream
   • DChange tracking stream
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What happens to a stream when a task consumes it by performing a DML operation on the stream?

   • AThe stream's offset advances, and the changes are no longer visible in the stream
   • BThe stream is automatically dropped
   • CThe stream becomes read-only
   • DThe stream's data is copied to a history table
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   How do you create a task dependency in Snowflake?

   • ABy setting a schedule that aligns with the predecessor's schedule
   • BBy using the AFTER keyword in the CREATE TASK statement
   • CBy placing the tasks in the same database schema
   • DBy using a stored procedure that calls the next task
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What is a common governance best practice for streams and tasks?

   • AUsing the same task for all pipelines to simplify management
   • BGranting all users the ability to create streams and tasks
   • CDropping streams immediately after they are consumed
   • DSetting a data retention time for streams to prevent staleness
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   In a task's cron expression, what does the '?' character represent?

   • ANo specific value
   • BA wildcard for a single character
   • CA comment indicator
   • DAny value
   Reveal Solution Discussion Select an answer first