Google Cloud Professional Cloud Database Engineer — Question 70

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Answer options

• A. Use Bigtable.
• B. Use Firestore.
• C. Use Cloud SQL for MySQL
• D. Use Cloud Spanner.

Correct answer: D

Explanation

Cloud Spanner is designed for high availability and global transactional consistency, making it suitable for applications that require these features. In contrast, Bigtable is optimized for analytics and not designed for relational transactions, Firestore focuses on NoSQL and doesn't guarantee the same level of consistency for complex transactions, and Cloud SQL for MySQL, while managed, does not scale to the same global consistency and availability as Cloud Spanner.