Databricks Certified Data Engineer Associate — Question 83

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?

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

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 and D are incorrect because they refer to static steps, which are not suitable for streaming tables. Option C is also incorrect, as the complexity of aggregations does not dictate the use of streaming syntax.