Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.

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

Explanation:

The CREATE STREAMING LIVE TABLE syntax should be used when data needs to be processed incrementally. This syntax is suitable for continuously updating data, where new records are processed as they arrive, making it ideal for real-time and streaming data applications.