Google Professional Cloud Database Engineer Question 171
Single answerGoogle Cloud PlatformYou manage a Cloud SQL instance hosting a MySQL database for an e-commerce application. During major sales events, such as Black Friday, the workload on the database is expected to increase significantly. How can you ensure the database instance scales appropriately to handle the increased workload while minimizing downtime and operational overhead?
- A
Enable Cloud SQL instance auto-scaling and set the appropriate CPU and memory thresholds.
- B
Manually increase the machine type of the Cloud SQL instance to a larger configuration before the sales event.
- C
Configure a read replica for the Cloud SQL instance to offload read-heavy traffic during the event.
- D
Use a managed instance group to automatically scale the Cloud SQL database instance.
Show answer and explanation
Correct answer: A
Explanation
Cloud SQL provides auto-scaling capabilities to dynamically adjust resource allocations based on workload patterns. This is the most efficient and low-overhead approach for handling sudden workload changes like those during large sales events. Manual scaling or read replicas can supplement performance but are not the best solution for dynamic scaling of the primary instance.
- A. Correct.
Correct. Enabling Cloud SQL instance auto-scaling allows the instance to dynamically adjust resources (such as CPU and memory) based on current and upcoming workload demands, minimizing downtime and operational effort.
- B. Incorrect.
Incorrect. Manually increasing the machine type of the instance is time-intensive and can cause downtime, making it less appropriate for handling dynamic workloads.
- C. Incorrect.
Incorrect. While read replicas can help distribute read traffic, they do not scale the primary instance to handle increased overall workload, including writes.
- D. Incorrect.
Incorrect. Managed instance groups are used for scaling virtual machines and are not applicable to scaling Cloud SQL database instances.