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 solution on Azure Databricks. The solution requires streaming data from multiple sources into a Delta table with live capabilities for immediate analytics. During the review of the CREATE TABLE statement syntax, you notice the absence of the LIVE keyword. Considering the requirements for real-time data processing and analytics, what is the impact of omitting the LIVE keyword, and what steps should be taken to ensure the solution meets its objectives? Choose the best option.
A
The omission of the LIVE keyword will result in the table being created as a regular Delta table, which does not support live streaming capabilities, thus failing to meet the real-time analytics requirement.
B
The omission of the LIVE keyword will not affect the table's creation, as the live streaming capabilities are automatically enabled for all Delta tables in a DLT pipeline.
C
The omission of the LIVE keyword will cause a syntax error, halting the pipeline execution and requiring immediate correction to proceed.
D
The omission of the LIVE keyword will allow the table to be created with live streaming capabilities, but it will not be optimized for real-time analytics, suggesting a review of the table's configuration is necessary.