
Ultimate access to all questions.
You are collaborating with the marketing team to set up a dashboard for ad campaign analysis. The team is uncertain about the dashboard's refresh frequency and has opted for manual refreshes as needed. Which of the following actions can help reduce compute costs when the dashboard is not in use? Note: Databricks has recently renamed SQL Endpoint to SQL Warehouses.
A
Decrease the cluster size of the SQL Warehouse.
B
Enable the Auto Stop feature for the SQL Warehouse.
C
Reduce the maximum bound of the SQL Warehouse's scaling range.
D
Activate the Serverless feature for the SQL Warehouse and switch the Spot Instance Policy from 'Reliability Optimized' to 'Cost optimized'.
E
Turn on the Serverless feature for the SQL Warehouse.