Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Which of the following 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?
Real Exam
Community
KKeng
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.
Explanation:
The correct answer is B because CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) is specifically designed for incremental data processing in Delta Live Tables. This syntax is used when you need to process data incrementally rather than performing full refreshes.
Key points:
- CREATE LIVE TABLE: Used for tables that require full refresh processing
- CREATE STREAMING LIVE TABLE: Used for tables that should process only new or changed data (incremental processing)
- This is particularly useful for streaming data sources or large datasets where reprocessing all data would be inefficient
- The other options are incorrect because:
- A: Incorrect - The subsequent step being static doesn't determine whether to use streaming tables
- C: Incorrect - CREATE STREAMING LIVE TABLE is not redundant; it serves a specific purpose for incremental processing
- D: Incorrect - Complicated aggregations can be done with both table types; this doesn't determine which syntax to use
- E: Incorrect - The previous step being static doesn't determine whether to use streaming tables
Comments
Loading comments...