Databricks Certified Data Engineer Associate — Question 92
Data engineer and data analysts are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?
Answer options
- A. The pipeline can have different notebook sources in SQL & Python
- B. The pipeline will need to be written entirely in SQL
- C. The pipeline will need to use a batch source in place of a streaming source
- D. The pipeline will need to be written entirely in Python
Correct answer: A
Explanation
The correct answer is A because Delta Live Tables allows the use of different languages for different parts of the pipeline, so the data engineer can continue using Python while the data analyst uses SQL. Option B is incorrect as the pipeline does not need to be exclusively SQL, option C is not true since Delta Live Tables supports streaming sources, and option D is incorrect because it does not require the entire pipeline to be in Python.