Google Professional Cloud Database Engineer Question 11
Select 2Google Cloud PlatformYour company runs a high-traffic e-commerce platform, and you are tasked with optimizing the performance and cost of your MySQL database hosted on Cloud SQL. The database experiences high IOPS during peak shopping hours, but moderate traffic during off-peak hours. Which of the following configurations would balance performance and cost most effectively?
- A
Use an n2-standard-8 instance with SSD storage and enable autoscaling.
- B
Use an e2-standard-4 instance with HDD storage to minimize costs.
- C
Use an n2-standard-16 instance with SSD storage to handle peak traffic without autoscaling.
- D
Use an n2-standard-4 instance with SSD storage and set up read replicas for peak traffic.
- E
Use an e2-standard-2 instance with HDD storage and enable automated backups.
Show answer and explanation
Correct answers: A, D
Explanation
Balancing performance and cost for high IOPS workloads requires selecting SSD storage for optimal disk performance and using appropriate machine types. Autoscaling or read replicas can handle peak loads efficiently without overprovisioning resources, ensuring cost-effectiveness during off-peak hours. Choosing configurations that provide scalability and sufficient performance without over-provisioning resources is key to achieving this balance.
- A. Correct.
This configuration uses a powerful machine type (n2-standard-8) with SSD storage for high IOPS demand, and autoscaling ensures you only pay for additional resources when needed. This balances performance and cost effectively.
- B. Incorrect.
While this configuration minimizes costs, HDD storage is not suitable for high IOPS workloads, and the e2-standard-4 instance may not handle peak traffic effectively, leading to degraded performance.
- C. Incorrect.
This configuration provides high performance with n2-standard-16 and SSD storage, but it does not include autoscaling, which means you pay for over-provisioned resources during off-peak hours, making it less cost-effective.
- D. Correct.
This configuration provides sufficient performance with n2-standard-4 and SSD storage, and read replicas can handle additional load during peak times, optimizing costs while maintaining performance.
- E. Incorrect.
This configuration minimizes costs but does not meet the performance requirements for high IOPS workloads, as both the e2-standard-2 instance and HDD storage are insufficient for the traffic demands.