BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 2 Question 25 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 25
Topic #: 2
[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?

Show Suggested Answer Hide Answer
Suggested Answer: D

In Databricks, you can use different languages within the same notebook by using magic commands. Magic commands are special commands that start with a percentage sign (%) and allow you to change the behavior of the cell. To use SQL within a cell of a Python notebook, you can add %sql to the first line of the cell. This will tell Databricks to interpret the rest of the cell as SQL code and execute it against the default database. You can also specify a different database by using the USE statement. The result of the SQL query will be displayed as a table or a chart, depending on the output mode. You can also assign the result to a Python variable by using the -o option. For example, %sql -o df SELECT * FROM my_table will run the SQL query and store the result as a pandas DataFrame in the Python variable df. Option A is incorrect, as it is possible to use SQL in a Python notebook using magic commands. Option B is incorrect, as attaching the cell to a SQL endpoint is not necessary and will not change the language of the cell. Option C is incorrect, as simply writing SQL syntax in the cell will result in a syntax error, as the cell will still be interpreted as Python code. Option E is incorrect, as changing the default language of the notebook to SQL will affect all the cells, not just one.Reference:Use SQL in Notebooks - Knowledge Base - Noteable, [SQL magic commands - Databricks], [Databricks SQL Guide - Databricks]


by Phil at May 07, 2024, 01:54 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
Delbert
5 months ago
Agreed with D. Attaching to a SQL endpoint, option B, sounds wrong to me.
upvoted 0 times
...
Dottie
5 months ago
Guys, C won't work. You need to specify the language. %sql makes sense.
upvoted 0 times
...
Jesusita
6 months ago
I was considering C, just writing SQL syntax directly. But not so sure.
upvoted 0 times
...
Margurite
6 months ago
I think it's D. Adding %sql to the first line should work.
upvoted 0 times
...
Delbert
6 months ago
Yeah, I am puzzled by that one. Any thoughts?
upvoted 0 times
...
Jesusita
6 months ago
Have you seen the question about using SQL in a Python notebook?
upvoted 0 times
...

Save Cancel