Ultimate access to all questions.
In a Databricks environment, a data engineer needs to ensure their SQL dashboard automatically refreshes daily. However, to optimize resource usage, they aim to limit the SQL endpoint's operation time to only when the refresh is necessary. What steps can the data engineer take to minimize the total active time of the SQL endpoint while still ensuring the dashboard is refreshed once per day?