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

Questions 21–25

1. 21foundation · easy

   What is a primary cost consideration when using tasks in Snowflake?

   • AThe cost of creating a stream on a table
   • BThe virtual warehouse usage for each task run
   • CThe storage cost of the stream itself
   • DThe cost of network egress for data transfer
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   When a task reads from a stream, what happens to the stream's offset?

   • AIt advances, making the processed changes unavailable to subsequent reads
   • BIt is reset to the beginning of the table's history
   • CIt remains unchanged until the task is dropped
   • DIt is set to the current timestamp
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What happens to a task's scheduled runs if the task fails?

   • AThe task continues to run on its schedule, and failures are recorded in the task history
   • BThe task is automatically suspended after a failure
   • CThe task's schedule is reset to the beginning
   • DThe task is dropped automatically
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is a Snowflake task?

   • AA stored procedure that runs automatically when data is inserted into a table
   • BA view that materializes query results for faster access
   • CA continuous data pipeline that processes streaming data in real time
   • DA scheduled SQL statement or stored procedure call that runs on a defined schedule
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which type of Snowflake stream records only new rows added to a source table, excluding updates and deletes?

   • AAppend-only stream
   • BChange-tracking stream
   • CTimestamp-based stream
   • DStandard stream
   Reveal Solution Discussion Select an answer first