Answer-first summary for fast verification
Answer: CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally. The CREATE STREAMING LIVE TABLE syntax is used to create tables that read data incrementally, while the CREATE LIVE TABLE syntax is used to create tables that read data in batch mode. Delta Live Tables (DLT) support both streaming and batch modes of processing data. When the data is streamed and needs to be processed incrementally, CREATE STREAMING LIVE TABLE should be used.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
In the context of creating Delta Live Tables (DLT) using SQL within Databricks, which of the following scenarios is most appropriate for employing the CREATE STREAMING LIVE TABLE (formerly known as CREATE INCREMENTAL LIVE TABLE) syntax instead of the CREATE LIVE TABLE syntax?
A
CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
B
CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
C
CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.
D
CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.
E
CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.