Databricks Certified Data Analyst Associate · Free Practice Question Medium
Question 4
A data analyst has set up a Databricks dashboard to auto-refresh periodically throughout the day. However, they have noticed that the associated SQL Warehouse is running constantly, leading to unexpectedly high costs, even during periods of inactivity when the dashboard is not being actively viewed. What should the analyst check to reduce these costs?
-
A
Disable the auto-refresh feature for the dashboard to prevent the SQL Warehouse from running constantly.
-
B
Increase the compute capacity of the SQL Warehouse to handle periods of inactivity more efficiently.
-
C
Reduce the dashboard refresh interval to lower the frequency of query execution.
-
D
Check the SQL Warehouse auto stop setting to ensure it shuts down after periods of inactivity when the dashboard is not being actively refreshed.
-
E
Manually stop the SQL Warehouse after each dashboard refresh.
Reveal correct answer
Correct answer: D
Explanation
The SQL Warehouse auto stop setting allows the SQL Warehouse to automatically shut down after a period of inactivity, helping to manage costs. In this case, the SQL Warehouse may be running continuously due to periodic dashboard refreshes, even when the dashboard is not actively being used. By configuring the auto stop feature, the analyst can ensure that the SQL Warehouse shuts down during idle periods, reducing unnecessary costs while still allowing the dashboard to refresh when needed.
Other options like reducing the refresh interval or disabling auto-refresh might limit functionality but won't address the core issue of controlling warehouse uptime and associated costs.
References:
https://learn.microsoft.com/en-us/azure/databricks/compute/sql-warehouse/create#--configure-sql-warehouse-settings
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
