Google Professional Cloud Database Engineer Question 247
Single answerGoogle Cloud PlatformYou are managing a Cloud Spanner database for a global e-commerce platform. The platform requires low-latency reads and writes across multiple continents to provide a seamless customer experience. The database must ensure strong consistency for transactions, even in the event of a regional failure. Which configuration should you implement to achieve this?
- A
Configure Cloud Spanner with a multi-region instance and specify a leader region.
- B
Use Cloud SQL with read replicas deployed in multiple regions.
- C
Set up a Memorystore instance in each region to cache database reads.
- D
Use Firestore in Datastore mode with multi-regional replication.
Show answer and explanation
Correct answer: A
Explanation
Cloud Spanner is designed for global, mission-critical applications that require strong consistency, low-latency reads, and writes across multiple regions. By configuring a multi-region instance and specifying a leader region, Cloud Spanner achieves optimal performance, availability, and durability, meeting the requirements of the given scenario. Other options either lack strong consistency or do not fully support the use case.
- A. Correct.
This is the correct choice. Cloud Spanner's multi-region instances provide low-latency access and strong consistency across multiple regions. Specifying a leader region ensures optimal write performance while maintaining global availability.
- B. Incorrect.
Cloud SQL with read replicas can provide multi-region read access but does not offer strong consistency or automatic failover in case of regional outages, making it unsuitable for this use case.
- C. Incorrect.
Memorystore is used as an in-memory caching solution, not for primary database replication. It does not provide strong consistency or automatic failover across regions.
- D. Incorrect.
Firestore in Datastore mode supports multi-regional replication, but it does not offer the same level of strong consistency and transactional guarantees as Cloud Spanner, making it less suitable for this scenario.