Answer-first summary for fast verification
Answer: Enable the Auto Stop feature for the SQL endpoint.
Enabling the Auto Stop feature allows the SQL warehouse to automatically terminate after being idle for a specified duration, thereby reducing unnecessary DBU and cloud instance charges. This is the most effective strategy for minimizing costs when automatic refreshes are not required. The correct choice is to enable the Auto Stop feature for the SQL endpoint.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data analysis team is conducting a social media campaign to market their company's new product. They utilize a Databricks SQL dashboard to monitor key metrics and visualizations of the campaign's performance. Since they do not require automatic dashboard refreshes, opting instead for manual refreshes as needed, which of the following strategies can they employ to minimize compute resource costs?
A
Enhance the SQL endpoint's scaling range by increasing its maximum bound.
B
Opt for a larger cluster size for the SQL endpoint.
C
Activate the Serverless feature for the SQL endpoint and select the 'Reliability Optimized' Spot Instance Policy.
D
Enable the Auto Stop feature for the SQL endpoint.
E
Switch on the Serverless feature for the SQL endpoint.
No comments yet.