A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
To minimize the total running time of the SQL endpoint used in the refresh schedule of a Databricks SQL dashboard, the data engineer can turn on the Auto Stop feature for the SQL endpoint. This feature ensures that the SQL endpoint stops automatically when it is idle, thus saving resources by only running when necessary for the dashboard refresh.
Ans A : the keyword in the question is " running only when its necessary "
A. They can turn on the Auto Stop feature for the SQL endpoint.
The correct answer is A. They can use the Auto Stop feature. When the query is idel it will stop the compute
They can turn on the Auto Stop feature
Answer is A. The question about minimize the total running times not enhance the performance.