Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.