Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all 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?
Real Exam
Community
KKeng
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
Explanation:
In Databricks notebooks, you can use language magic commands to specify the language for individual cells. To use SQL in a Python notebook cell, you need to add %sql as the first line of that specific cell. This tells Databricks to interpret the cell content as SQL code while keeping other cells as Python. Option A is incorrect because it is possible to use SQL in Python notebooks. Option B is incorrect because attaching to a SQL endpoint doesn't enable SQL syntax in a Python notebook cell. Option C is incorrect because simply writing SQL syntax without the magic command will cause an error. Option E is incorrect because changing the default language would affect all cells, not just the specific one.
Comments
Loading comments...