Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Question 40
A data analyst has noticed that their Databricks SQL queries are running too slowly. They claim that this issue is affecting all of their sequentially run queries. They ask the data engineering team for help. The data engineering team notices that each of the queries uses the same SQL endpoint, but the SQL endpoint is not used by any other user.
Which of the following approaches can the data engineering team use to improve the latency of the data analyst's queries?
Real Exam
Community
LLeetQuiz
A
They can turn on the Serverless feature for the SQL endpoint.
B
They can increase the maximum bound of the SQL endpoint's scaling range.
C
They can increase the cluster size of the SQL endpoint.
D
They can turn on the Auto Stop feature for the SQL endpoint.
E
They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
Explanation:
Correct Answer: C — Increase the cluster size of the SQL endpoint
Why C is Correct:
- Sequential queries use one worker at a time
- Larger cluster size = more power per worker (CPU, memory)
- Directly improves performance for each individual query
Why B is Incorrect:
- Scaling range controls number of workers for handling concurrent queries
- Since queries run sequentially (not concurrently), more workers won't help
- Would only help if multiple users were querying simultaneously
Why Others Are Wrong:
- A & E (Serverless): Improves startup time/manageability, not query speed
- D (Auto Stop): Cost-saving feature, doesn't affect performance
Comments
Loading comments...