Exam Certified Data Engineer Associate topic 1 question 142 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 142
Topic #: 1

[All Certified Data Engineer Associate Questions]

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?

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

Show Suggested Answer

Suggested Answer: A 🗳️

by comoon at Nov. 2, 2024, 12:08 p.m.

Comments

Submit Cancel

MultiCloudIronMan

1 month, 3 weeks ago

Selected Answer: A

The correct answer is A. The pipeline can have different notebook sources in SQL & Python. Delta Live Tables supports both SQL and Python, as well as streaming and batch sources. Therefore, the existing pipeline can continue to use both SQL and Python for different layers without needing to be rewritten entirely in one language or switching from a streaming to a batch source.

upvoted 4 times

...

Worldmaster

2 months ago

Selected Answer: A

Imho A is correct

upvoted 1 times

...

rsmf

3 months ago

Selected Answer: C

C is correct

upvoted 1 times

...

comoon

3 months ago

C is correct

upvoted 1 times

...

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 142 discussion

Comments

MultiCloudIronMan

Worldmaster

rsmf

comoon

SY0-701