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

Questions 1–5

1. 1foundation · easy

   What is a task DAG in Snowflake?

   • AA sequence of tasks that run in a fixed order
   • BA directed acyclic graph of tasks where each task can have dependencies on other tasks
   • CA tree of tasks where each task has exactly one parent
   • DA group of tasks that run concurrently without dependencies
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   How does a standard stream handle an UPDATE operation on a source table?

   • AIt records only the old row with METADATA$ACTION = 'DELETE'
   • BIt records only the new row with METADATA$ACTION = 'UPDATE'
   • CIt does not record updates because they are not supported
   • DIt records two rows: one with METADATA$ACTION = 'DELETE' and one with METADATA$ACTION = 'INSERT', both with METADATA$ISUPDATE = TRUE
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which command is used to temporarily stop a task from running without dropping it?

   • AALTER TASK ... STOP;
   • BALTER TASK ... SUSPEND;
   • CALTER TASK ... PAUSE;
   • DDROP TASK ...;
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is a limitation of streams when DDL changes are made to the source table?

   • AStreams are dropped automatically when DDL changes are made
   • BStreams only support DML changes and ignore DDL changes entirely
   • CSome DDL changes can cause the stream to become stale or require recreation
   • DStreams automatically adapt to any DDL change without issue
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which metadata column in a Snowflake stream indicates whether a row is an insert, update, or delete?

   • AMETADATA$ACTION
   • BMETADATA$TIMESTAMP
   • CMETADATA$ROW_ID
   • DMETADATA$ISUPDATE
   Reveal Solution Discussion Select an answer first