Free Databricks Certified Data Engineer Associate Actual Exam Questions - Question 14 Discussion
INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables
(DLT) tables using SQL?
It’s B because streaming implies handling data as it arrives, so incremental fits best.
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.
B imo, streaming is all about handling data incrementally by design.
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.
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.
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.
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.
B for sure, it's about handling data as it arrives, incrementally.
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.