A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
Using a Serverless SQL endpoint can reduce the start-up time for the endpoint while managing costs. Serverless SQL endpoints automatically scale resources based on the workload, ensuring efficient utilization without needing manual intervention. This approach eliminates the need to manage cluster size or scaling values directly and helps minimize start-up delays by leveraging pre-existing resources.
Options A, B, and C would impact costs. While Option D could enhance cluster responsiveness, it may not necessarily reduce start-up time. The correct choice is Option E because serverless SQL endpoints automatically scale resources based on the workload, ensuring efficient utilization without the need for manual intervention.
Answer E is correct
Serverless SQL endpoints automatically scale resources based on the workload. Databricks have a pool of clusters for users to borrow from when we need them.