After running a SQL query in the Databricks SQL editor, a data analyst wants to create a bar chart from the result set. What is the correct built-in way to create the chart without leaving the SQL editor?
Answer & explanation
Correct answer: B
WHY B: In the Databricks SQL editor, after running a query, you click the '+' tab next to the Results tab to create a new visualization directly from the result set. The visualization editor lets you choose the chart type (bar, line, scatter, etc.) and configure column mappings — all without leaving the SQL editor. WHY NOT A: Exporting to CSV and using external tools is a valid workaround but is not the built-in SQL editor workflow for creating visualizations. WHY NOT C: While display() works in a separate Python notebook, it requires a different environment and converting the result set to a DataFrame; this bypasses the SQL editor's native visualization feature. WHY NOT D: Navigating to AI/BI Dashboards is a separate product surface and is not required for creating a quick visualization from the SQL editor. WHY NOT E: There is no PLOT keyword in Databricks SQL syntax; chart creation uses the UI editor, not SQL-level keywords.