Google Professional Cloud Database Engineer Question 173
Select 3Google Cloud PlatformYou are managing a Cloud SQL instance running MySQL for an e-commerce application. During holiday sales, the workload on the database is expected to increase significantly due to high traffic from customers. You want to ensure the database can handle the increased load while minimizing manual intervention. What steps should you take to prepare for this workload spike?
- A
Enable automatic storage increase for your Cloud SQL instance.
- B
Configure read replicas for the database to distribute read traffic.
- C
Manually increase the instance size to the largest available machine type.
- D
Set up a custom alerting policy to monitor CPU and memory utilization.
- E
Enable automatic scaling for the database instance’s CPU and memory.
Show answer and explanation
Correct answers: A, B, D
Explanation
To handle workload spikes effectively, it is essential to rely on automated features like automatic storage increase and read replicas to manage scale and distribute traffic. Additionally, setting up custom alerting policies ensures you can monitor resource utilization and respond to potential issues in real-time. While manual scaling of instance size might work, it is not an efficient approach, and Cloud SQL does not support automatic scaling of CPU and memory.
- A. Correct.
Correct: Enabling automatic storage increase ensures that the database storage expands as needed during high traffic, avoiding downtime caused by exceeding storage limits.
- B. Correct.
Correct: Configuring read replicas allows you to offload read-heavy operations to replicas, improving overall performance and reducing the load on the primary instance.
- C. Incorrect.
Incorrect: Increasing the instance size manually might help with performance, but it is not a scalable or automated solution, and it requires additional monitoring and intervention.
- D. Correct.
Correct: Setting up custom alerting policies helps you proactively monitor and address potential issues with CPU and memory utilization during workload spikes.
- E. Incorrect.
Incorrect: Cloud SQL does not support automatic CPU and memory scaling. You would need to manually scale these resources or use other strategies like read replicas.