Google Cloud Professional Cloud Database Engineer — Question 110

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

Answer options

• A. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
• B. Use Cloud Spanner in a multi-region configuration.
• C. Use Firestore in Datastore mode.
• D. Use a Bigtable instance with clusters in multiple regions.

Correct answer: B

Explanation

The correct choice is B, Cloud Spanner in a multi-region configuration, as it is designed to handle global transactions with strong consistency and can efficiently manage both structured and semi-structured data while scaling across multiple regions. Option A, Cloud SQL for PostgreSQL, does not offer the same level of scalability and consistency across regions. Option C, Firestore in Datastore mode, is not optimized for strong consistency in transactional workloads. Lastly, Option D, Bigtable, is suited for large-scale analytics but does not support transactions and strong consistency.