Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Other Sources
Community
UAnonymous
A
CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
B
CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
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.
Explanation:
In Delta Live Tables (DLT), the CREATE STREAMING LIVE TABLE syntax is used when the data source or transformation requires incremental processing. This means that instead of processing the entire dataset every time, only the new or changed data is processed. This is particularly useful for streaming data sources or scenarios where efficiency and low-latency updates are important. The CREATE LIVE TABLE syntax, on the other hand, is used for batch processing where the entire dataset is processed at once. Using CREATE STREAMING LIVE TABLE ensures that the pipeline can handle continuous data ingestion and transformation without reprocessing all historical data.
Comments
Loading comments...