Answer-first summary for fast verification
Answer: They can turn on the Auto Stop feature for the SQL endpoint.
The correct approach to minimize the total running time of the SQL endpoint is to turn on the Auto Stop feature for the SQL endpoint. This feature will automatically stop the compute resources when the queries are idle, ensuring that the endpoint is only running when necessary. This minimizes unnecessary compute time and associated costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is working on a Databricks SQL dashboard that is composed of multiple queries accessing various datasets. The underlying data for these queries is automatically processed using a Databricks Job. The goal is to schedule this dashboard to refresh every hour while minimizing the total runtime of the SQL endpoint required for these refresh queries. To accomplish this, the data engineer wants the SQL endpoint to be active only during necessary periods. Which of the following strategies can the data engineer implement to achieve this optimization in the refresh schedule of their dashboard?
A
They can turn on the Auto Stop feature for the SQL endpoint.
B
They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
C
They can reduce the cluster size of the SQL endpoint.
D
They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
E
They can set up the dashboard's SQL endpoint to be serverless.
No comments yet.