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:
Explanation
In Databricks notebooks, you can use different languages within the same notebook by using magic commands at the beginning of a cell. The %sql magic command tells Databricks to interpret the cell's content as SQL code, regardless of the notebook's default language.
Why option D is correct:
- Adding
%sqlto the first line of a cell explicitly tells Databricks to execute that cell as SQL - This allows mixing languages within the same notebook without changing the default language
- Other cells can continue using Python without any modifications
Why other options are incorrect:
- A: It IS possible to use SQL in a Python notebook using magic commands
- B: Attaching to a SQL endpoint is not required; magic commands work with standard clusters
- C: Simply writing SQL syntax without
%sqlwould cause a syntax error in a Python notebook - E: Changing the default language would affect all cells, not just the specific cell where SQL is needed
Key Takeaway: Databricks notebooks support language-agnostic cells through magic commands (%sql, %python, %scala, %r), allowing data engineers to use the most appropriate language for each task within the same notebook.
Comments
Loading comments...