DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #29
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Question
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?
Options
- 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
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.