Databricks Certified Data Analyst Associate — Question 43

A data analyst has opened up the SQL Editor page and written a new SQL statement. The data analyst now wants to save that statement to easily refer back to it later to add it to a dashboard. The results of the SQL statement must be able to be displayed as a counter, table, or a data visualization.

Which approach should the data analyst use to accomplish this task?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C, as saving the SQL statement as a Query allows it to be easily retrieved and utilized in dashboards or visualizations. Options A and B do not specifically refer to storing the SQL statement in a way that allows for direct use in dashboards, while option D merely keeps a history of queries without the ability to save them for repeated use.