Answer-first summary for fast verification
Answer: Use a Serverless SQL endpoint
The question asks for a solution to reduce SQL endpoint start-up time while managing costs. Option E (Use a Serverless SQL endpoint) is the correct choice because serverless endpoints automatically scale resources based on workload demand, eliminating the need for cluster provisioning and reducing start-up time significantly. The community discussion strongly supports this with 100% consensus on E, noting that serverless compute is efficient and automatically scales without manual intervention. Other options are less suitable: A and B (reducing/increasing cluster size) don't address start-up delays and may increase costs; C (turning off Auto stop) keeps the cluster running continuously, increasing costs without solving the root cause; D (increasing minimum scaling) may improve responsiveness but doesn't guarantee reduced start-up time and could raise costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data analyst has configured a SQL query to execute every four hours on a SQL endpoint, but the endpoint is experiencing slow start-up times for each run. Which of the following modifications can the data analyst implement to decrease the endpoint's start-up time while also controlling costs?
A
Reduce the SQL endpoint cluster size
B
Increase the SQL endpoint cluster size
C
Turn off the Auto stop feature
D
Increase the minimum scaling value
E
Use a Serverless SQL endpoint