Answer-first summary for fast verification
Answer: Expand the maximum scaling range of the SQL Warehouse’s clusters.
The correct action is to increase the maximum scaling range of the SQL Warehouse’s clusters. This allows more clusters to be added, enabling queries to run on available clusters instead of waiting in a queue. This approach is particularly effective when queries are running concurrently, as it scales out the resources. Scaling up (increasing the warehouse size) is more suitable for improving the performance of individual queries running sequentially. Understanding when to scale out (add more clusters) versus scale up (increase cluster size) is crucial for optimizing SQL Warehouse performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You've observed that Databricks SQL queries are running slower than expected. Upon investigation, you find that all queries are running in parallel on a SQL Warehouse with a single cluster. What steps can you take to enhance the performance and reduce response times? *Note: Databricks has recently renamed SQL endpoint to SQL warehouse.
A
Enable the Serverless feature for the SQL Warehouse and adjust the Spot Instance Policy to “Reliability Optimized.”
B
Increase the warehouse size from 2X-Small to 4X-Large.
C
Activate the Auto Stop feature for the SQL Warehouse.
D
Expand the maximum scaling range of the SQL Warehouse’s clusters.
E
Turn on the Serverless feature for the SQL Warehouse.
No comments yet.