Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Get Unlimited Access

Databricks Discussions

Exam Certified Data Analyst Associate topic 1 question 6 discussion

Actual exam question from Databricks's Certified Data Analyst Associate

Question #: 6
Topic #: 1

[All 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?

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

Show Suggested Answer

Suggested Answer: E 🗳️

by plants4food at Feb. 20, 2024, 1:43 a.m.

Comments

Submit Cancel

Ayush24

1 month, 1 week ago

Selected Answer: E

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.

upvoted 1 times

...

markiz

1 month, 3 weeks ago

Answer E is correct

upvoted 2 times

...

plants4food

2 months, 4 weeks ago

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.