Certified Data Engineer Associate Exam

Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam

Question 33

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?

CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.

CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.

CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.

CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.

CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

Correct Answer: B

CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally. This syntax is appropriate for tables that read and process data in a continuous, incremental manner, updating as new data arrives. This is in contrast to the CREATE LIVE TABLE syntax, which is used for tables that process data in batch mode, dealing with static datasets at a time. As such, for use cases requiring incremental updates and streaming data handling, CREATE STREAMING LIVE TABLE is the correct choice.

Discussion

XiltroXOption: B

B is the correct answer.

4be8126Option: B

B. CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally. The CREATE STREAMING LIVE TABLE syntax is used to create tables that read data incrementally, while the CREATE LIVE TABLE syntax is used to create tables that read data in batch mode. Delta Live Tables support both streaming and batch modes of processing data. When the data is streamed and needs to be processed incrementally, CREATE STREAMING LIVE TABLE should be used.

surrabhi_4Option: B

option B

vctrhugoOption: B

B. CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally. The CREATE STREAMING LIVE TABLE syntax is used when you want to create Delta Live Tables (DLT) tables that are designed for processing data incrementally. This is typically used when your data pipeline involves streaming or incremental data updates, and you want the table to stay up to date as new data arrives. It allows you to define tables that can handle data changes incrementally without the need for full table refreshes. So, option B correctly describes when to use CREATE STREAMING LIVE TABLE over CREATE LIVE TABLE in the context of Delta Live Tables.

ZSun

This is old version question, currently, Databricks only have Streaming Table (Create Live Table). The previous Streaming live table and Live table already combined.

lgkofficialwork

is this dump valid for v3?

SerGreyOption: B

B is correct

awofalusOption: B

B is correct