Google Professional Cloud Database Engineer Question 14
Single answerGoogle Cloud PlatformYou are designing a Cloud SQL instance to support a transactional e-commerce application that requires high IOPS and low latency for its database operations. The application workload is expected to grow substantially over time. You need to select the appropriate machine type and storage configuration to balance performance and cost. What configuration should you choose?
- A
Use a high-memory machine type with SSD storage.
- B
Use a standard machine type with HDD storage.
- C
Use a high-CPU machine type with SSD storage.
- D
Use a standard machine type with SSD storage.
Show answer and explanation
Correct answer: A
Explanation
For an e-commerce application with high transactional demands, selecting a high-memory machine type ensures sufficient memory to optimize query performance and caching, while SSD storage guarantees high IOPS and low latency for database operations. This configuration provides the best balance of performance and cost, particularly for workloads that are expected to grow over time.
- A. Correct.
This option is correct because a high-memory machine type with SSD storage provides the required high IOPS and low latency for a transactional database, while also offering better performance for memory-intensive workloads, such as caching and query execution, in e-commerce applications.
- B. Incorrect.
This option is incorrect because HDD storage has significantly lower IOPS and higher latency compared to SSDs, which would not meet the performance requirements of a transactional e-commerce application.
- C. Incorrect.
This option is incorrect because while a high-CPU machine type with SSD storage might provide sufficient computational resources, it may not adequately handle the memory-intensive nature of a transactional database workload.
- D. Incorrect.
This option is incorrect because a standard machine type, even with SSD storage, would not provide the required performance for a high-demand transactional workload, especially as the application scales.