Databricks Certified Data Analyst Associate Exam - Topic 3 Question 45 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam

Question #: 45
Topic #: 3

[All Databricks Certified Data Analyst Associate Questions]

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?

AReduce the SQL endpoint cluster size

BIncrease the SQL endpoint cluster size

CTurn off the Auto stop feature

DIncrease the minimum scaling value

EUse a Serverless SQL endpoint
A Serverless SQL endpoint is a type of SQL endpoint that does not require a dedicated cluster to run queries. Instead, it uses a shared pool of resources that can scale up and down automatically based on the demand. This means that a Serverless SQL endpoint can start up much faster than a SQL endpoint that uses a cluster, and it can also save costs by only paying for the resources that are used. A Serverless SQL endpoint is suitable for ad-hoc queries and exploratory analysis, but it may not offer the same level of performance and isolation as a SQL endpoint that uses a cluster. Therefore, a data analyst should consider the trade-offs between speed, cost, and quality when choosing between a Serverless SQL endpoint and a SQL endpoint that uses a cluster.Reference:Databricks SQL endpoints,Serverless SQL endpoints,SQL endpoint clusters

Show Suggested Answer

Suggested Answer: E

by Tennie at Nov 25, 2025, 04:59 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Harrison

2 months ago

Yeah, but it might affect performance. Serverless seems safer.

upvoted 0 times

...

Talia

2 months ago

Reducing the cluster size could help too, right?

upvoted 0 times

...

Lenna

2 months ago

True, but for ad-hoc queries, speed is crucial.

upvoted 0 times

...

Josefa

2 months ago

But what about performance? Serverless might not be as strong.

upvoted 0 times

...

Blondell

2 months ago

Agreed! It starts up faster and saves costs.

upvoted 0 times

...

Brittni

2 months ago

Auto stop feature should definitely be turned off!

upvoted 0 times

...

Christiane

3 months ago

Wait, can Serverless really handle heavy queries?

upvoted 0 times

...

Kenny

3 months ago

Reducing the cluster size could help too.

upvoted 0 times

...

Linsey

3 months ago

I disagree, you might lose performance with Serverless.

upvoted 0 times

...

Kip

4 months ago

A Serverless SQL endpoint sounds like a good option!

upvoted 0 times

...

Rosamond

4 months ago

Haha, a Serverless SQL endpoint, eh? Sounds like the data analyst is trying to avoid the "SQL endpoint startup blues." Good call!

upvoted 0 times

...

Ira

4 months ago

Hmm, E) Serverless SQL endpoint, eh? Gotta love that automatic scaling. Beats dealing with a slow-starting cluster any day.

upvoted 0 times

...

Rodolfo

4 months ago

A Serverless SQL endpoint seems like the perfect solution to reduce the startup time. I'm curious to see how the performance compares to a dedicated cluster.

upvoted 0 times

...

Belen

4 months ago

Using a Serverless SQL endpoint sounds like a good idea since it can scale automatically, but I wonder if it would handle heavy queries as well as a dedicated cluster.

upvoted 0 times

...

Shenika

4 months ago

I practiced a similar question where increasing the minimum scaling value was suggested, but I’m not clear if that would actually help in this case.

upvoted 0 times

...

Rutha

5 months ago

I think reducing the cluster size might help, but it could also impact performance. I need to double-check how that affects start-up times.

upvoted 0 times

...

Selma

5 months ago

I remember we discussed how serverless options can really speed things up, but I'm not sure if it's the best choice for every situation.

upvoted 0 times

...

Denna

5 months ago

I'm leaning towards the Serverless SQL endpoint too. The speed and cost benefits seem to outweigh the potential drawbacks, especially since this is just for a regular reporting query. As long as the data quality and reliability aren't compromised, I think it's worth trying out.

upvoted 0 times

...

Dominga

5 months ago

I'm a little confused by all these options. What are the pros and cons of each one? I want to make sure I understand the tradeoffs before I decide which one to recommend. Can someone break it down for me in simple terms?

upvoted 0 times

...

Carlee

5 months ago

E) Serverless SQL endpoint sounds like the way to go. Faster startup and cost savings? Sign me up!

upvoted 0 times

...

Jestine

6 months ago

I think using a Serverless SQL endpoint is the best option.

upvoted 0 times

...

Aretha

6 months ago

The Serverless SQL endpoint seems like the way to go here. Sure, there might be some performance differences, but if the main issue is the startup time, that's the best solution. And the cost savings are a nice bonus. I'd say go for it and see how it works - we can always adjust later if needed.

upvoted 0 times

...

Noel

6 months ago

Hmm, I'm not sure about the Serverless SQL endpoint. I know it's supposed to be faster, but I'm worried about the trade-offs in terms of performance and isolation. Maybe we should look into increasing the cluster size instead? That might give us the speed boost we need without sacrificing too much.

upvoted 0 times

...

Melissa

6 months ago

I think the Serverless SQL endpoint option sounds like the best choice here. It seems like it would start up much faster than the current SQL endpoint, which is the main issue we're trying to address. And the cost savings could be a nice bonus.

upvoted 0 times