Answer-first summary for fast verification
Answer: They can turn on the Auto Stop feature for the SQL endpoint.
The data engineer can use the Auto Stop feature to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard. The Auto Stop feature allows the SQL endpoint to automatically shut down when there are no active connections, which will minimize the total running time of the SQL endpoint. By scheduling the dashboard to refresh once per day, the SQL endpoint will only be running for a short period of time each day, which will minimize the total running time and reduce costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is managing a Databricks SQL dashboard that requires daily refreshes. To optimize resources, they aim to ensure the SQL endpoint associated with the dashboard is operational only when essential for the refresh process. Which method should the data engineer employ to minimize the overall active duration of the SQL endpoint during the dashboard's refresh schedule?
A
They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
B
They can set up the dashboard’s SQL endpoint to be serverless.
C
They can turn on the Auto Stop feature for the SQL endpoint.
D
They can reduce the cluster size of the SQL endpoint.
E
They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.
No comments yet.