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

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

Question #: 19
Topic #: 1

[All Databricks Certified Data Engineer Associate 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

Bambi

3 months ago

Wait, really? You can just add %sql? That’s cool!

upvoted 0 times

...

Micah

3 months ago

Changing the whole notebook to SQL seems unnecessary.

upvoted 0 times

...

Willodean

3 months ago

Definitely %sql for SQL queries in Python cells!

upvoted 0 times

...

Belen

4 months ago

I thought you couldn't mix languages in a notebook?

upvoted 0 times

...

Filiberto

4 months ago

You can use %sql in a Python cell, super handy!

upvoted 0 times

...

Kristin

4 months ago

I feel like changing the default language of the notebook to SQL might not be the right approach, but I can't recall the exact details.

upvoted 0 times

...

Olen

4 months ago

I practiced a question similar to this, and I think the answer was about changing the cell type with a specific command.

upvoted 0 times

...

Mari

4 months ago

I’m not entirely sure, but I think you can’t just write SQL directly in a Python cell without some kind of prefix.

upvoted 0 times

...

Emogene

5 months ago

I remember something about using magic commands in notebooks, maybe adding %sql at the start of a cell?

upvoted 0 times

...

Jodi

5 months ago

The key here is that the data engineer wants to use SQL in a specific cell, while keeping the rest of the notebook in Python. Based on that, I think the best approach is to use the %sql magic command, which is option D.

upvoted 0 times

...

Myong

5 months ago

Okay, let me think this through step-by-step. The question says we want to use SQL in a Python notebook, without changing the other cells. That means we need a way to switch the language just for that specific cell. I'm pretty sure the %sql magic command is the way to do that.

upvoted 0 times

...

Markus

5 months ago

Hmm, I'm a little unsure about this one. I know we can use SQL in Databricks notebooks, but I'm not sure of the exact syntax. I'll have to think this through carefully.

upvoted 0 times

...

Kizzy

5 months ago

This seems like a pretty straightforward question. I'm pretty confident the answer is D - adding %sql to the first line of the cell.

upvoted 0 times

...

Robt

5 months ago

I'm a bit confused by this question. I thought Databricks notebooks were either Python or SQL, not a mix. But if we can use SQL in a Python notebook, then I guess the answer must be D - adding %sql to the cell.

upvoted 0 times

...

Andra

5 months ago

Okay, I remember that Type 4 LSAs are used to advertise ASBR routers. Since R1 is the ASBR, it should be generating the Type 4 LSA.

upvoted 0 times

...

Lauran

5 months ago

Okay, I've got this. The key is to make sure the product owner is fully on board with the business requirements. That's the best way to ensure the end product meets their needs.

upvoted 0 times

...