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

Questions 11–15

1. 11foundation · easy

   How does a stream prevent reprocessing of the same changes?

   • ABy automatically deleting consumed rows from the stream
   • BBy storing a flag on each row indicating whether it has been processed
   • CBy advancing its offset when a DML statement reads from it
   • DBy requiring the task to explicitly mark rows as processed
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A task consumes a stream and inserts data into a target table. The task runs every 10 minutes. After a successful run, the stream offset advances. The team wants to ensure that the stream is consumed exactly once and no data is missed. What is the correct way to consume the stream in the task?

   • AUse a single INSERT statement that reads from the stream and inserts into the target table.
   • BUse a stored procedure to read the stream and insert the data in a loop.
   • CUse multiple INSERT statements in the task, each reading from the same stream.
   • DUse a SELECT statement to read the stream and then a separate INSERT statement to insert the data.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A task needs to run every 5 minutes, but only on weekdays. The team is in the UTC timezone and wants the schedule to be based on UTC. Which schedule configuration should they use?

   • AUSING CRON '*/5 * * * * MON-FRI'
   • BUSING CRON '0 */5 * * * MON-FRI'
   • CSCHEDULE = '5 MINUTE' TIMEZONE = 'UTC'
   • DSCHEDULE = '5 MINUTE'
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which Snowflake view or function can you use to monitor task run history?

   • AACCOUNT_USAGE.TASKS view
   • BSTREAM_HISTORY() table function
   • CQUERY_HISTORY() table function
   • DTASK_HISTORY() table function
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   How does a stream capture change data on a Snowflake table?

   • ABy leveraging Snowflake's time travel and metadata to track changes since the last transaction
   • BBy using triggers that fire on every DML statement
   • CBy storing a copy of every row after each change
   • DBy continuously polling the table for new rows
   Reveal Solution Discussion Select an answer first