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
Mob_nav_barsMENU

Databricks Exam Databricks Certified Data Engineer Associate Topic 4 Question 54 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam
Question #: 54
Topic #: 4
[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 Zana at Aug 14, 2025, 01:03 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:

Submit Cancel
Doyle
2 days ago
I remember practicing a question about when to use streaming vs. live tables, and I think it had something to do with the nature of the data processing.
upvoted 0 times
...
Ocie
8 days ago
I think CREATE STREAMING LIVE TABLE is for when we need to process data incrementally, but I'm not completely sure.
upvoted 0 times
...
Delbert
13 days ago
I've got a strategy for this. I'll focus on understanding the differences in how the data is processed between the two options, and then match that to the scenarios described in the answer choices.
upvoted 0 times
...
Caitlin
18 days ago
Based on the question, it seems like the CREATE STREAMING LIVE TABLE is used when the subsequent step in the pipeline is static. That makes sense, but I'll double-check the other options too.
upvoted 0 times
...
Arthur
23 days ago
I'm a bit confused on this one. I'll need to review the documentation on Delta Live Tables to make sure I understand the use cases for each syntax.
upvoted 0 times
...
Iraida
28 days ago
Okay, let's see. I think the key is understanding when data needs to be processed incrementally. That's probably the main difference between the two options.
upvoted 0 times
...
Rusty
1 month ago
Hmm, this one seems tricky. I'll need to think carefully about the differences between CREATE STREAMING LIVE TABLE and CREATE LIVE TABLE.
upvoted 0 times
...
Ciara
2 months ago
B is the answer, duh! Streaming live tables are for incremental data processing, everyone knows that.
upvoted 0 times
...
Curt
2 months ago
I believe D) CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.
upvoted 0 times
...
Reyes
3 months ago
I agree with Jerilyn, using CREATE STREAMING LIVE TABLE makes sense for incremental processing.
upvoted 0 times
...
Jerilyn
3 months ago
I think B) CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
upvoted 0 times
...

Save Cancel