Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When working on a project that requires both SQL and Python in a Databricks notebook, what is the most efficient approach?
A
Use separate notebooks for SQL and Python to avoid confusion.
B
Leverage the magic commands %sql and %python within a single notebook to switch between languages.
C
Deploy an All-purpose cluster for Python and a SQL endpoint for SQL queries.
D
Utilize a job cluster for Python execution and a SQL endpoint for SQL queries.