Question
Dynamic tables versus streams and tasks: how do their operating models differ, and when should each be used?
Answer
Dynamic tables materialize a SELECT result and refresh it automatically to a target lag. Streams expose row-level CDC since an offset; tasks run scheduled or event-triggered work. Use dynamic tables for declarative transformations; use streams and tasks for procedural CDC processing.