Answer-first summary for fast verification
Answer: CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?
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 should be used when data needs to be processed through complicated aggregations.
D
CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.
