Answer-first summary for fast verification
Answer: Activate the Auto Stop feature for the SQL endpoint.
The Auto Stop feature automatically shuts down the SQL endpoint after a period of inactivity, optimizing resource usage and reducing costs. This ensures the endpoint is only active when necessary, aligning with efficient resource management practices in Databricks SQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer wants to set a daily refresh schedule for their Databricks SQL dashboard and wishes to have the associated SQL endpoint active only when needed. Which method should the data engineer employ to keep the SQL endpoint‘s operational time to a minimum for the dashboard‘s refresh schedule?
A
Configure the dashboard's SQL endpoint to operate in a serverless mode.
B
Make sure the dashboard's SQL endpoint is not linked to any of the queries' SQL endpoints.
C
Ensure the dashboard's SQL endpoint aligns with each query's SQL endpoint.
D
Decrease the cluster size of the SQL endpoint.
E
Activate the Auto Stop feature for the SQL endpoint.
