Google Professional Cloud Database Engineer Question 182
Select 3Google Cloud PlatformYour company runs a Cloud SQL for PostgreSQL instance to support a critical business application. The database workload has periodic spikes in traffic, leading to temporary over-provisioning of resources. Your team has been tasked with optimizing the cost of this database solution while ensuring it meets performance demands. Which of the following actions would help you achieve this goal?
- A
Enable autoscaling for read replicas to handle traffic spikes dynamically.
- B
Switch from a zonal instance to a regional instance for better fault tolerance.
- C
Set up a schedule to automatically stop the database during non-peak hours.
- D
Analyze query performance using the Query Insights feature and optimize slow-running queries.
- E
Downgrade the database instance type to a smaller machine without evaluating current utilization.
Show answer and explanation
Correct answers: A, C, D
Explanation
Optimizing the cost of running a database solution requires balancing performance with resource utilization. Autoscaling read replicas ensures efficient handling of spikes while avoiding over-provisioning. Scheduling the database to stop during idle periods reduces unnecessary costs. Analyzing and optimizing queries decreases computational overhead and resource usage. However, changes like downgrading the instance type should only be made after careful analysis of utilization metrics to avoid performance issues.
- A. Correct.
Enabling autoscaling for read replicas allows the system to handle temporary traffic spikes dynamically and efficiently without over-provisioning, which can optimize costs.
- B. Incorrect.
Switching to a regional instance improves fault tolerance but does not directly reduce costs. In fact, it could increase costs due to redundancy.
- C. Correct.
Setting up a schedule to stop the database during non-peak hours can significantly reduce costs by avoiding resource usage when the database is idle.
- D. Correct.
Using Query Insights to analyze and optimize slow-running queries reduces resource consumption, which can lead to cost savings by requiring less compute power.
- E. Incorrect.
Downgrading the database instance without evaluating utilization could result in under-provisioning, leading to poor performance and potential service disruptions. This is not a safe cost-optimization strategy.