Databricks Certified Data Engineer Associate — Question 103

A data engineer and data analyst 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 will need to be written entirely in Python
• B. The pipeline will need to stop using the medallion-based multi-hop architecture
• C. The pipeline will need to be written entirely in SQL
• D. The pipeline will need to use a batch source in place of a streaming source

Correct answer: D

Explanation

The correct answer is D because Delta Live Tables require a batch source for data ingestion, unlike traditional streaming sources. The other options are incorrect as Delta Live Tables do not necessitate a complete rewrite in either Python or SQL, nor do they require abandoning the medallion architecture.