Google Professional Cloud Database Engineer Question 169
Select 3Google Cloud PlatformYou are managing a Cloud SQL instance running a PostgreSQL database for an e-commerce application. During peak shopping hours, the database experiences increased read and write queries, causing high CPU utilization and slower response times. You need to ensure the database can scale based on current and upcoming workloads while minimizing downtime and operational overhead. What should you do?
- A
Enable read replicas for the Cloud SQL instance to offload read queries.
- B
Configure the Cloud SQL instance to use horizontal scaling by adding more database nodes.
- C
Set up an alert to monitor CPU utilization and manually scale the instance when needed.
- D
Use Cloud SQL instance auto-scaling to automatically adjust the instance's resources based on workload.
- E
Upgrade to a higher machine type with more CPU and memory resources.
Show answer and explanation
Correct answers: A, D, E
Explanation
To effectively scale a Cloud SQL instance based on current and upcoming workloads, you should use a combination of read replicas for scaling read operations, Cloud SQL auto-scaling for dynamic resource adjustments, and vertical scaling by upgrading the machine type for higher capacity. These approaches ensure minimal downtime and operational overhead while addressing workload demands. Horizontal scaling (adding database nodes) is not supported by Cloud SQL, and manual scaling is less efficient compared to automated solutions.
- A. Correct.
Enabling read replicas allows you to offload read queries to the replicas, reducing the load on the primary instance and improving performance during peak hours. This is a recommended approach for scaling read-heavy workloads.
- B. Incorrect.
Cloud SQL does not support horizontal scaling (adding database nodes) as it is designed for vertical scaling or read replicas. This option is not applicable in this scenario.
- C. Incorrect.
Manually scaling the instance by monitoring metrics and acting on alerts can be time-consuming and may result in delayed responses to workload spikes. It is not an efficient or automated solution for dynamic scaling.
- D. Correct.
Cloud SQL provides auto-scaling for certain configurations, such as for memory and CPU adjustments in flexible configurations. Auto-scaling ensures the instance can dynamically adjust resources based on workload without manual intervention.
- E. Correct.
Upgrading to a higher machine type with more CPU and memory allows the database to handle increased workloads effectively. This is a form of vertical scaling, which is supported by Cloud SQL.