Google Professional Cloud Database Engineer Question 17
Single answerGoogle Cloud PlatformYour company is deploying a new e-commerce application on Google Cloud that requires a database with high write throughput to handle frequent order updates. The database is also expected to scale as demand increases during seasonal spikes. Which configuration would best meet these requirements when using Cloud Spanner?
- A
Use a single-node Cloud Spanner instance with regional configuration to minimize costs.
- B
Provision a multi-node Cloud Spanner instance with regional configuration and monitor CPU utilization to scale nodes as needed.
- C
Use a single-node Cloud Spanner instance with multi-region configuration for high availability.
- D
Provision a multi-node Cloud Spanner instance with multi-region configuration to handle write throughput and ensure global availability.
Show answer and explanation
Correct answer: B
Explanation
The e-commerce application requires high write throughput and scalability. A multi-node Cloud Spanner instance with regional configuration allows for scaling write performance by adding nodes and is more cost-effective than a multi-region setup, which is not necessary for this use case. Monitoring CPU utilization ensures that scaling decisions are based on actual demand.
- A. Incorrect.
A single-node Cloud Spanner instance is not suitable for high write throughput or scaling during peak loads. This option minimizes costs but does not meet the performance requirements.
- B. Correct.
A multi-node Cloud Spanner instance with regional configuration provides high write throughput and the ability to scale by adding nodes. Monitoring CPU utilization ensures that scaling aligns with performance needs.
- C. Incorrect.
A single-node instance with multi-region configuration offers high availability but does not support the required write throughput or scalability.
- D. Incorrect.
While a multi-node instance with multi-region configuration ensures global availability, it is unnecessary if the application does not require global writes and would increase costs unnecessarily.