ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Analyst Associate All Questions

View all questions & answers for the Certified Data Analyst Associate exam
Go to Exam

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 Hide Answer
Suggested Answer: E 🗳️
by plants4food at Feb. 20, 2024, 1:43 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ayush24
6 months, 3 weeks 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 3 times
...
markiz
7 months, 1 week ago
Answer E is correct
upvoted 2 times
...
plants4food
8 months, 2 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.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago