Answer-first summary for fast verification
Answer: Save the SQL statement as a Query
The correct answer is C because saving the SQL statement as a Query allows the data analyst to easily refer back to it later and add it to a dashboard with results displayable as a counter, table, or visualization. In Databricks, saved Queries are specifically designed for this purpose - they can be executed, scheduled, and their results can be visualized in dashboards. Option A (Dashboard) is incorrect because you save query results to dashboards, not the SQL statements themselves. Option B (Notebook) would work but is less optimal as it's not the dedicated tool for this specific use case. Option D (Query History) is temporary and doesn't provide persistent storage for future reference.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data analyst has created a new SQL statement in the SQL Editor and wants to save it for future reference and to add it to a dashboard. The saved query results must be displayable as a counter, table, or visualization.
Which method should the data analyst use?
A
Save the SQL statement as a Dashboard
B
Save the SQL statement within a Notebook
C
Save the SQL statement as a Query
D
Save the SQL statement in the Query History page
No comments yet.