Exam Certified Data Engineer Associate topic 1 question 56 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 56
Topic #: 1

[All 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?

A. It is not possible to use SQL in a Python notebook
B. They can attach the cell to a SQL endpoint rather than a Databricks cluster
C. They can simply write SQL syntax in the cell
D. They can add %sql to the first line of the cell
E. They can change the default language of the notebook to SQL

Show Suggested Answer

Suggested Answer: D 🗳️

by meow_akk at Oct. 22, 2023, 4:36 a.m.

Comments

Submit Cancel

80370eb

8 months, 2 weeks ago

Selected Answer: D

we can use magic comment in notebook to indicate the cell to be run in specific language %SQL.

upvoted 1 times

...

azure_bimonster

1 year, 3 months ago

Selected Answer: D

Magic command % can be used to switch the language, so D is correct

upvoted 1 times

...

bartfto

1 year, 3 months ago

Selected Answer: D

D. Correct. Use %sql magic in first line.

upvoted 1 times

...

Lavpak

1 year, 5 months ago

Selected Answer: D

Use magic command %sql

upvoted 3 times

...

MFEST

1 year, 5 months ago

correct answer D

upvoted 3 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 56 discussion

Comments

80370eb

azure_bimonster

bartfto

Lavpak

MFEST

SY0-701