Free Databricks Certified Data Engineer Associate Actual Exam Questions - Question 14 Discussion

Question No. 14
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?
Select one option, then reveal solution.
US
AS
Ali S.
2026-02-16

It’s B because streaming implies handling data as it arrives, so incremental fits best.

0
AS
Ali S.
2026-02-09

It’s B because streaming tables are meant for incremental data processing, unlike CREATE LIVE TABLE which is more for batch or static data. The focus is definitely on handling new data continuously.

0
AS
Ali S.
2026-02-05

B imo, streaming is all about handling data incrementally by design.

0
AS
Ali S.
2026-02-04

B/E? I think B fits since streaming means handling data incrementally. But E’s about previous step being static which could mean you want to start streaming after a static load. Still, B feels more directly related.

0
DJ
Daniel J.
2026-02-02

Option C can be tossed because the syntax was renamed, so it’s definitely not redundant. D is off since streaming isn’t about complexity but data flow. That leaves B as the solid choice for incremental processing.

0
DJ
Daniel J.
2026-01-31

D imo, the key thing is that streaming tables are designed to handle continuous data input, not just complex aggregations. So D doesn’t seem right. Also, E and A talk about previous or next steps being static, which feels unrelated to when you’d choose a streaming table. C sounds like it’s saying streaming syntax doesn’t matter, which conflicts with the idea of incremental processing. B fits best because streaming tables are all about processing data as it arrives, incrementally updating the table rather than batch replacing it.

0
CC
Chris C.
2026-01-30

Guessing B too, since streaming implies handling new data continuously, not just static snapshots or complicated aggregations. It’s about incremental updates more than the complexity of data transformation.

0
PP
Peter P.
2026-01-19

B for sure, it's about handling data as it arrives, incrementally.

0
AU
Andre U.
2026-01-16

Not C, since the syntax change was meant for a reason. I think B fits best here because streaming tables process data incrementally, which seems like the core use case.

0