In the context of creating Delta Live Tables (DLT) using SQL, which scenario is best suited for using the CREATE STREAMING LIVE TABLE syntax as opposed to the CREATE LIVE TABLE syntax? Note that CREATE STREAMING LIVE TABLE was formerly known as CREATE INCREMENTAL LIVE TABLE.

Exam-Like

CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.

3.1%

CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.

91.2%

CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.

3.1%

CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

2.6%

Databricks Certified Data Engineer - Associate