Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Certified Data Engineer Associate Exam - Topic 5 Question 58 Discussion

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?
B) CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
A) CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
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.

Databricks Certified Data Engineer Associate Exam - Topic 5 Question 58 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam
Question #: 58
Topic #: 5
[All Databricks Certified Data Engineer Associate 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?

Show Suggested Answer Hide Answer
Suggested Answer: B

A streaming live table or view processes data that has been added only since the last pipeline update. Streaming tables and views are stateful; if the defining query changes, new data will be processed based on the new query and existing data is not recomputed. This is useful when data needs to be processed incrementally, such as when ingesting streaming data sources or performing incremental loads from batch data sources. A live table or view, on the other hand, may be entirely computed when possible to optimize computation resources and time. This is suitable when data needs to be processed in full, such as when performing complex transformations or aggregations that require scanning all the data.Reference:Difference between LIVE TABLE and STREAMING LIVE TABLE,CREATE STREAMING TABLE,Load data using streaming tables in Databricks SQL.


by Maryrose at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rene
2 months ago
But D is also valid. Complicated aggregations might need streaming for efficiency.
upvoted 0 times
...
Lorita
2 months ago
A seems reasonable too. If the next step is static, why stream?
upvoted 0 times
...
Darci
2 months ago
I agree, B makes sense. Static steps don’t need streaming.
upvoted 0 times
...
Han
3 months ago
I think B is the best choice. Incremental processing is key for streaming.
upvoted 0 times
...
Claribel
3 months ago
E? Really? That sounds a bit confusing to me.
upvoted 0 times
...
Kimberlie
3 months ago
D is interesting, but I’m not sure it’s necessary.
upvoted 0 times
...
Shaun
3 months ago
Wait, C seems off. Why would it be redundant?
upvoted 0 times
...
Aleta
3 months ago
I think A makes sense too, but not as much as B.
upvoted 0 times
...
Andra
3 months ago
B is definitely the right choice! Incremental processing is key.
upvoted 0 times
...
Janessa
4 months ago
Gotta love these DLT questions - really keeps you on your toes!
upvoted 0 times
...
Toi
4 months ago
B) for the win! Incremental processing is the whole point of streaming live tables.
upvoted 0 times
...
Alethea
4 months ago
Hmm, I'm torn between B) and E). Guess I'll have to study up on my DLT syntax.
upvoted 0 times
...
Jarvis
5 months ago
C) is just plain wrong. Streaming live tables are a key feature of DLT.
upvoted 0 times
...
Vashti
5 months ago
D) sounds like a good option, but I think B) is the right choice here.
upvoted 0 times
...
Wilda
5 months ago
B) is the correct answer. Streaming live tables are used for incremental data processing.
upvoted 0 times
...
Alona
5 months ago
I recall that CREATE STREAMING LIVE TABLE is specifically for incremental processing, so B seems to fit best, but I could be wrong.
upvoted 0 times
...
Truman
5 months ago
I practiced a similar question, and I feel like CREATE STREAMING LIVE TABLE is not needed if the next step is static, which might make A or C correct?
upvoted 0 times
...
Kaitlyn
5 months ago
I'm a bit unsure, but I remember something about using CREATE STREAMING LIVE TABLE when the previous step is static. Could it be E?
upvoted 0 times
...
Hyun
6 months ago
I think CREATE STREAMING LIVE TABLE is mainly for when we need to handle data incrementally, so maybe B is the right choice?
upvoted 0 times
...
Sheridan
6 months ago
The key is understanding when data needs to be processed incrementally. That should help me determine the right syntax to use.
upvoted 0 times
...
Cristy
6 months ago
I'm a bit confused on the difference between these two syntax options. I'll need to re-read the documentation to make sure I get this right.
upvoted 0 times
...
Thea
6 months ago
Okay, I'm pretty confident I understand when to use CREATE STREAMING LIVE TABLE. I'll jot down the key points before answering.
upvoted 0 times
...
Lawrence
6 months ago
Hmm, this seems like a tricky one. I'll need to think through the use cases for each syntax carefully.
upvoted 0 times
...
Joana
7 months ago
I think I know the difference between CREATE STREAMING LIVE TABLE and CREATE LIVE TABLE, but I'll need to review the details to be sure.
upvoted 0 times
Ty
5 days ago
What about D? Complicated aggregations could also fit.
upvoted 0 times
...
Kattie
10 days ago
Agreed! B makes the most sense for streaming.
upvoted 0 times
...
Vanesa
16 days ago
I believe B is the right choice. Incremental processing is key.
upvoted 0 times
...
...

Save Cancel