Databricks Data Engineer Associate Question 413
Select 3You are troubleshooting a Delta Live Tables (DLT) pipeline that has failed. The error message indicates a syntax issue in one of the transformation notebooks. Upon investigation, you find the following issues in the pipeline's logic:
- One of the create statements is missing the 'LIVE' keyword.
- A streaming source query is missing the 'STREAM' keyword in the 'FROM' clause.
Which of the following steps should you take to resolve these issues?
- A
Add the 'LIVE' keyword before the table name in the create statement.
- B
Ensure the 'STREAM' keyword is used in the 'FROM' clause for the streaming source.
- C
Replace 'LIVE' with 'TEMP' in the create statement to fix the syntax issue.
- D
Remove the 'STREAM' keyword from the 'FROM' clause as it is unnecessary.
- E
Verify that the notebook containing the errors is correctly referenced in the pipeline configuration.
Show answer and explanation
Correct answers: A, B, E
Explanation
To resolve the syntax issues in the Delta Live Tables pipeline, you must use the 'LIVE' keyword in create statements to define managed tables, and the 'STREAM' keyword in the 'FROM' clause when dealing with streaming sources. Additionally, verifying the pipeline configuration ensures that the correct notebook is being executed, which helps in identifying and fixing errors effectively.
- A. Correct.
Correct: The 'LIVE' keyword is mandatory in Delta Live Tables create statements to identify managed tables.
- B. Correct.
Correct: The 'STREAM' keyword is required in the 'FROM' clause when reading from streaming sources in Delta Live Tables pipelines.
- C. Incorrect.
Incorrect: 'TEMP' is not a valid replacement for 'LIVE' in Delta Live Tables. The 'LIVE' keyword is required to define managed tables.
- D. Incorrect.
Incorrect: Removing the 'STREAM' keyword from the 'FROM' clause would cause the pipeline to fail when reading from a streaming source.
- E. Correct.
Correct: Verifying the notebook configuration ensures the pipeline correctly references and executes the proper notebook containing the transformations.