Answer-first summary for fast verification
Answer: Expand the maximum bound of the SQL Warehouse’s scaling range.
The correct action is to increase the maximum bound of the SQL Warehouse’s scaling range. This allows for the addition of more clusters to the warehouse, enabling it to handle more queries simultaneously during peak times. This solution is about scaling out (adding more clusters) rather than scaling up (increasing the size of the cluster), which is more about improving the performance of individual queries rather than increasing throughput. Understanding when to scale out versus scale up is crucial for optimizing both performance and cost in a Databricks SQL Warehouse environment.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To address the issue of queries taking longer to finish during peak hours on a SQL Warehouse (formerly SQL Endpoint), which of the following steps would be most effective?
A
Enable the Serverless feature for the SQL Warehouse.
B
Adjust the Spot Instance Policy from 'Cost optimized' to 'Reliability Optimized' and enable the Serverless feature.
C
Increase the cluster size from 2X-Small to 4X-Large of the SQL Warehouse.
D
Expand the maximum bound of the SQL Warehouse’s scaling range.
E
Activate the Auto Stop feature for the SQL Warehouse.
No comments yet.