Databricks Certified Data Engineer Associate — Question 13

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because CREATE STREAMING LIVE TABLE is specifically designed for scenarios where data is processed incrementally, allowing for real-time updates. Options A, D, and E are incorrect as they describe situations where streaming is not necessary, and option C is wrong because CREATE STREAMING LIVE TABLE has a distinct purpose within the DLT framework.