Google Professional Cloud Database Engineer Question 15
Single answerGoogle Cloud PlatformYou are designing a database solution on Google Cloud for a retail application that processes high volumes of transactions and requires low-latency responses. The database will store structured data and the workload is write-intensive. Cost is a consideration, but performance is the primary priority. Which configuration should you choose to best meet the requirements?
- A
Use a Cloud SQL instance with an n2-standard-2 machine type and HDD storage.
- B
Use a Cloud Spanner instance with regional configuration and SSD storage.
- C
Use a Cloud SQL instance with an n2-highmem-8 machine type and SSD storage.
- D
Use a Firestore database in Datastore mode with multi-regional configuration.
Show answer and explanation
Correct answer: B
Explanation
Cloud Spanner is a distributed relational database service that provides high scalability, strong consistency, and low-latency performance, making it ideal for write-intensive transactional workloads. Using SSD storage further optimizes performance for these requirements. The regional configuration balances performance needs and cost considerations, making it the most suitable choice for this scenario.
- A. Incorrect.
This option uses HDD storage, which is not optimized for write-intensive workloads and low-latency requirements. Additionally, the n2-standard-2 machine type may not provide sufficient resources for high transaction volumes.
- B. Correct.
This option uses Cloud Spanner with SSD storage, which is designed for high scalability, low-latency performance, and can handle write-intensive workloads effectively. The regional configuration helps reduce costs compared to multi-regional setups while still providing strong consistency.
- C. Incorrect.
While the n2-highmem-8 machine type and SSD storage offer better performance than HDD, Cloud SQL is not as scalable or optimized for high write-intensive workloads as Cloud Spanner. This could become a bottleneck under high transaction volumes.
- D. Incorrect.
Firestore in Datastore mode is a NoSQL database optimized for different use cases such as hierarchical or document-based data. It is not the best choice for structured, write-intensive, and low-latency transactional workloads.