Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 1 Question 19 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate Exam exam

Question #: 19
Topic #: 1

[All Databricks Certified Data Engineer Associate Exam Questions]

A data engineer has a Python notebook in Databricks, but they need to use SQL to accomplish a specific task within a cell. They still want all of the other cells to use Python without making any changes to those cells.

Which of the following describes how the data engineer can use SQL within a cell of their Python notebook?

AIt is not possible to use SQL in a Python notebook

BThey can attach the cell to a SQL endpoint rather than a Databricks cluster

CThey can simply write SQL syntax in the cell

DThey can add %sql to the first line of the cell

EThey can change the default language of the notebook to SQL

Show Suggested Answer

Suggested Answer: D

by Xochitl at Feb 12, 2024, 11:08 PM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Data-Engineer-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Wilda

10 days ago

I think the answer is D) They can add %sql to the first line of the cell.

upvoted 0 times

...