Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE…

A streaming live table or view processes data that has been added only since the last pipeline

update. Streaming tables and views are stateful; if the defining query changes, new data will be

processed based on the new query and existing data is not recomputed. This is useful when data

needs to be processed incrementally, such as when ingesting streaming data sources or performing

incremental loads from batch data sources. A live table or view, on the other hand, may be entirely

computed when possible to optimize computation resources and time. This is suitable when data

needs to be processed in full, such as when performing complex transformations or aggregations

that require scanning all the data. Reference: Difference between LIVE TABLE and STREAMING LIVE

TABLE, CREATE STREAMING TABLE, Load data using streaming tables in Databricks SQL.