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

Questions 11–15

1. 11foundation · easy

   What does a stream's offset represent?

   • AThe number of rows in the stream
   • BThe timestamp of the last DML operation on the source table
   • CThe position in the source table's history from which changes are tracked
   • DThe version of the stream object
   Reveal Solution Discussion Select an answer first
2. 12application · easy

   A data engineer creates a stream on a table and then performs an ALTER TABLE operation to add a new column. What happens to the stream?

   • AThe stream is automatically converted to an append-only stream.
   • BThe stream continues to work and will capture changes to the new column.
   • CThe stream drops all existing data and starts fresh.
   • DThe stream becomes stale and must be recreated.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which system view or function can be used to monitor the execution of tasks in a DAG?

   • ATASK_STATUS()
   • BSTREAM_HISTORY()
   • CTASK_HISTORY()
   • DQUERY_HISTORY()
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What does a Snowflake stream track on a source table?

   • AThe query history of all users accessing the table
   • BThe current snapshot of the table's data
   • CThe history of all DDL statements executed on the table
   • DThe changes (inserts, updates, deletes) made to the table since the last offset
   Reveal Solution Discussion Select an answer first
6. 15expert · medium

   A data engineer creates a stream on a table and then performs a TRUNCATE TABLE operation. What happens to the stream?

   • AThe stream continues to work and captures the truncate as an insert operation.
   • BThe stream continues to work and captures the truncate as a delete operation.
   • CThe stream is automatically converted to an append-only stream.
   • DThe stream becomes stale and must be recreated.
   Reveal Solution Discussion Select an answer first