
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.