Google Professional Cloud Database Engineer Question 12
Single answerGoogle Cloud PlatformYour team is designing a Cloud SQL instance for a new application with a moderate workload that requires low latency and high IOPS. The application is read-heavy, and cost efficiency is a priority. Which configuration would best balance performance and cost for this use case?
- A
Use an n2-standard-4 machine type with SSD persistent disks.
- B
Use an n2-highmem-8 machine type with SSD persistent disks.
- C
Use an e2-standard-4 machine type with HDD persistent disks.
- D
Use an e2-micro machine type with HDD persistent disks.
Show answer and explanation
Correct answer: A
Explanation
The n2-standard-4 machine type with SSD persistent disks provides the best balance of performance and cost for a moderate, read-heavy workload with low latency and high IOPS requirements. The SSD persistent disks ensure sufficient IOPS, and the n2-standard-4 machine type offers adequate compute resources without incurring unnecessary costs. Other configurations either fail to meet performance requirements or are unnecessarily costly for the described workload.
- A. Correct.
This option provides a balanced configuration of compute power (n2-standard-4), sufficient for moderate workloads, and SSD persistent disks, which deliver high IOPS at a reasonable cost compared to HDDs. This setup meets both performance needs and cost efficiency.
- B. Incorrect.
While this configuration offers better memory and SSD performance, it is overprovisioned for a moderate workload and significantly increases costs, making it less cost-efficient.
- C. Incorrect.
HDD persistent disks are cost-effective but do not meet the low latency and high IOPS requirements for this use case. Additionally, the e2-standard-4 machine type may not provide optimal performance for the workload.
- D. Incorrect.
This configuration is the least expensive but not suitable for the use case due to the e2-micro machine's limited resources and the poor performance of HDD persistent disks for high IOPS requirements.