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?
Suggested Answer: E
Get Premium Databricks Certified Data Analyst Associate Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
27 comments · newest first
CO
Cortney
I wouldn’t turn off the Auto stop feature. That’s risky.
LA
Lamonica
5 days ago
Increasing the minimum scaling value could also help.
DE
Delisa
10 days ago
Yeah, but that could affect performance.
NO
Noble
15 days ago
Reducing the cluster size might help too, but not as much.
CO
Cortney
21 days ago
True, but for ad-hoc queries, it works well.
LA
Lamonica
26 days ago
But what about performance?
DE
Delisa
1 month ago
Agreed! It’s faster and cost-effective.
NO
Noble
1 month ago
I think using a Serverless SQL endpoint is the best option.
TH
Thersa
1 month ago
Same here! It’s a smart move overall.
GR
Gracie
2 months ago
I’d stick with Serverless for flexibility.
VI
Vi
2 months ago
Right, it might save costs but won’t speed things up.
TH
Thersa
2 months ago
Reducing cluster size could help too, but not as much.
GR
Gracie
2 months ago
True, but for ad-hoc queries, it’s perfect.
VI
Vi
2 months ago
Performance might drop for heavy queries.
TH
Thersa
2 months ago
Exactly! But what about performance?
GR
Gracie
3 months ago
Plus, no need for a dedicated cluster.
TH
Thersa
3 months ago
Agreed! It’s faster and cost-effective.
GR
Gracie
3 months ago
I think using a Serverless SQL endpoint is the best option.
BR
Brinda
3 months ago
Definitely consider the trade-offs with Serverless options.
DA
Darci
3 months ago
Surprised that turning off Auto stop is even an option!
AN
Andra
3 months ago
Reducing the cluster size might help, but is it enough?
TO
Tomoko
4 months ago
I think increasing the cluster size is a bad idea, costs will skyrocket.
MO
Mollie
4 months ago
A Serverless SQL endpoint can really speed things up!
GE
Genevive
4 months ago
I feel like turning off the Auto stop feature could actually slow things down, but I'm not completely certain.
JE
Jean
4 months ago
I practiced a similar question where increasing the minimum scaling value helped, but I can't recall if it applies here.
GE
Gertude
4 months ago
I think reducing the cluster size could help, but it might impact performance too.
LI
Lina
4 months ago
I remember something about serverless options being faster, but I'm not sure if they fit all use cases.