Answer-first summary for fast verification
Answer: Expand the maximum bound of the SQL endpoint’s scaling range.
The correct action is to increase the maximum bound of the SQL endpoint’s scaling range. This allows more clusters to be added, enabling queries to run on available clusters instead of waiting in the queue. This approach is effective for improving throughput during peak usage times by scaling out (adding more clusters). Scaling up (increasing cluster size) is more suited for improving the performance of individual queries rather than handling increased concurrency. The Serverless feature and Auto Stop feature do not directly address the issue of concurrent query performance degradation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When setting up a SQL Endpoint, you observe that query performance degrades during peak hours as the number of concurrent users increases, causing the same queries to take longer to run. Which of the following actions can help resolve this issue?
A
Increase the cluster size of the SQL endpoint from 2X-Small to 4X-Large.
B
Turn on the Serverless feature for the SQL endpoint and adjust the Spot Instance Policy to 'Reliability Optimized'.
C
Enable the Auto Stop feature for the SQL endpoint.
D
Expand the maximum bound of the SQL endpoint’s scaling range.
E
Activate the Serverless feature for the SQL endpoint.
No comments yet.