Google Professional Cloud Database Engineer Question 180
Select 2Google Cloud PlatformYou are managing a Cloud SQL instance for a production workload. The database usage patterns have recently changed, resulting in higher costs than expected. You want to continuously optimize the cost of the database solution without impacting availability or performance. Which of the following actions should you take?
- A
Enable the Query Insights feature to analyze database queries and identify inefficiencies.
- B
Switch to a smaller machine type without analyzing the workload requirements.
- C
Set up automated backups to a regional storage bucket to reduce storage costs.
- D
Use idle instance recommendations in the Google Cloud Console to identify underutilized resources.
- E
Implement read replicas to reduce read traffic on the primary instance.
Show answer and explanation
Correct answers: A, D
Explanation
To continuously optimize the cost of running a database solution, it is important to analyze query inefficiencies using tools like Query Insights and leverage Google Cloud's built-in recommendations to identify and reduce underutilized resources. These actions optimize resource utilization without compromising availability or performance. Other options either increase costs or fail to directly address cost optimization.
- A. Correct.
Enabling Query Insights allows you to analyze query performance and detect inefficiencies, which can help optimize costs by improving query execution and reducing resource usage.
- B. Incorrect.
Switching to a smaller machine type without analyzing workload requirements can lead to performance bottlenecks and increased latency, which is not an optimal solution.
- C. Incorrect.
Automated backups are useful for disaster recovery but do not directly contribute to cost optimization for the database solution.
- D. Correct.
Idle instance recommendations in the Google Cloud Console help identify underutilized resources, enabling you to downsize or terminate them to reduce costs.
- E. Incorrect.
Implementing read replicas can improve read performance but typically increases overall costs due to additional resources being used.