New Year Sale 2026! 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
Jarvis
3 days ago
C) is just plain wrong. Streaming live tables are a key feature of DLT.
upvoted 0 times
...
Vashti
8 days ago
D) sounds like a good option, but I think B) is the right choice here.
upvoted 0 times
...
Wilda
13 days ago
B) is the correct answer. Streaming live tables are used for incremental data processing.
upvoted 0 times
...
Alona
18 days 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
24 days 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
29 days 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
1 month 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
1 month 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
1 month 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
2 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
2 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
2 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