Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are designing a Delta Live Table (DLT) pipeline for a real-time analytics application that processes streaming data from IoT devices. The pipeline must ensure low latency data processing to provide timely insights. During the review of your pipeline's query syntax, you notice that the STREAM keyword is missing from the FROM clause when reading data from a streaming source. Considering the requirements of low latency processing and the need for accurate data ingestion, what is the impact of omitting the STREAM keyword, and how should this issue be addressed? Choose the best option from the following:
A
The omission of the STREAM keyword will allow the query to read data from the streaming source as a regular table, but this approach may not meet the low latency requirements due to the lack of streaming capabilities.
B
The omission of the STREAM keyword will cause a syntax error, preventing the query from executing, which directly impacts the pipeline's ability to process streaming data in real-time.
C
The omission of the STREAM keyword will have no impact on the query execution, as the DLT pipeline automatically detects and adjusts for streaming sources without explicit keywords.
D
The omission of the STREAM keyword will cause the query to read data from the streaming source with increased latency, as it defaults to batch processing, thus failing to meet the real-time processing requirement.