Google Professional Cloud Database Engineer Question 183
Select 3Google Cloud PlatformYou are managing a relational database hosted on Google Cloud SQL for a production environment. Recently, your organization has noticed a spike in database costs due to underutilized resources. What actions can you take to continuously assess and optimize the cost of the database solution while ensuring performance is not compromised?
- A
Enable automatic storage increases to minimize downtime.
- B
Regularly review and adjust the instance size based on query performance and CPU/memory utilization metrics.
- C
Use the Cloud SQL Insights tool to identify and optimize inefficient queries consuming excessive resources.
- D
Enable high availability (HA) to ensure cost savings by reducing resource usage during failover.
- E
Schedule backups during off-peak hours to reduce the impact on performance and optimize resource usage.
Show answer and explanation
Correct answers: B, C, E
Explanation
To continuously assess and optimize the cost of a database solution, you need to monitor resource utilization, adjust provisioning dynamically, and address inefficiencies in query execution. Regularly reviewing instance size, using tools like Cloud SQL Insights to optimize queries, and scheduling backups to reduce peak-time resource usage are practical approaches to achieve cost savings without compromising performance.
- A. Incorrect.
Enabling automatic storage increases is a good practice to prevent downtime but does not directly optimize cost. It ensures storage grows as needed but won't reduce costs for underutilized resources.
- B. Correct.
Adjusting the instance size based on CPU/memory utilization ensures that the database is not overprovisioned, which can lead to cost savings while maintaining performance.
- C. Correct.
Using Cloud SQL Insights helps identify inefficient queries that consume excessive resources. Optimizing these queries can reduce resource usage and costs.
- D. Incorrect.
Enabling high availability (HA) improves reliability during failover but does not reduce resource usage. In fact, it can increase costs due to the additional resources required for HA.
- E. Correct.
Scheduling backups during off-peak hours helps optimize resource usage and minimizes the performance impact on the database, indirectly contributing to cost-effectiveness.