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

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
Shaun
1 day ago
Wait, C seems off. Why would it be redundant?
upvoted 0 times
...
Aleta
6 days ago
I think A makes sense too, but not as much as B.
upvoted 0 times
...
Andra
11 days ago
B is definitely the right choice! Incremental processing is key.
upvoted 0 times
...
Janessa
17 days ago
Gotta love these DLT questions - really keeps you on your toes!
upvoted 0 times
...
Toi
22 days ago
B) for the win! Incremental processing is the whole point of streaming live tables.
upvoted 0 times
...
Alethea
27 days ago
Hmm, I'm torn between B) and E). Guess I'll have to study up on my DLT syntax.
upvoted 0 times
...
Jarvis
2 months ago
C) is just plain wrong. Streaming live tables are a key feature of DLT.
upvoted 0 times
...
Vashti
2 months ago
D) sounds like a good option, but I think B) is the right choice here.
upvoted 0 times
...
Wilda
2 months ago
B) is the correct answer. Streaming live tables are used for incremental data processing.
upvoted 0 times
...
Alona
2 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
2 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
2 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
3 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
3 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
3 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
3 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
3 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
3 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
...

Save Cancel