Google Professional Cloud Database Engineer Question 181
Select 2Google Cloud PlatformYou are managing a Cloud SQL PostgreSQL instance for your organization. After a recent review, your team has identified that database costs have significantly increased. Which of the following actions should you take to optimize the cost of running this database solution while maintaining performance and availability?
- A
Enable automatic storage increase to avoid downtime due to insufficient storage.
- B
Resize the instance to a smaller machine type with fewer CPUs and memory if the current usage is below 50% of capacity.
- C
Enable Query Insights to identify and optimize inefficient queries consuming excessive resources.
- D
Disable high availability (HA) for the instance to reduce costs.
- E
Schedule automated backups during off-peak hours to minimize resource contention.
Show answer and explanation
Correct answers: B, C
Explanation
To optimize the cost of running a Cloud SQL database, resizing the instance to align with actual usage and improving query efficiency are effective strategies. These actions reduce resource consumption without compromising performance or availability. Other options, like disabling HA or enabling automatic storage increase, may impact availability or lead to higher costs in the long term.
- A. Incorrect.
Enabling automatic storage increase does not directly optimize costs; instead, it ensures availability but could lead to higher expenses if storage usage continues to grow.
- B. Correct.
Resizing the instance to a smaller machine type when usage is consistently low can significantly reduce costs without impacting performance, provided resource needs are met.
- C. Correct.
Enabling Query Insights allows you to identify and optimize inefficient queries, which can reduce resource consumption and, in turn, lower costs.
- D. Incorrect.
Disabling high availability (HA) can reduce costs but compromises availability and failover capabilities, which is generally not recommended for production workloads.
- E. Incorrect.
Scheduling automated backups during off-peak hours can improve performance but does not directly contribute to cost optimization.