Answer-first summary for fast verification
Answer: Use Cloud Spanner in a multi-region configuration.
The airline ticketing application requires a database that can handle transactions with strong consistency, work with both structured and semi-structured data, and scale transparently across multiple regions globally. Cloud Spanner is the best choice among the options provided because it is a fully managed relational database that offers strong consistency, supports SQL and JSON data, and can scale globally with multi-region configurations. Cloud SQL for PostgreSQL (Option A) does not offer the same level of global scalability and strong consistency across regions as Cloud Spanner. Firestore in Datastore mode (Option C) is more suited for document storage and does not provide strong consistency by default. Bigtable (Option D) is a NoSQL database that is optimized for large analytical and operational workloads but does not support SQL transactions or strong consistency across regions as required by the application.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What Google Cloud database solution should you choose for an airline ticketing application that requires transaction support with strong consistency, handles both structured and semi-structured (JSON) data, and can scale seamlessly across multiple global regions as demand increases?
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.
No comments yet.