Google Professional Cloud Database Engineer Question 70
Single answerGoogle Cloud PlatformYour company is migrating its on-premises relational database to Google Cloud. The database stores transactional financial data and requires high availability with automatic failover and strong consistency. Additionally, the team wants minimal operational overhead and the ability to scale seamlessly as the workload grows. Which Google Cloud database solution should you recommend?
- A
Cloud SQL
- B
Spanner
- C
BigQuery
- D
Cloud Firestore
Show answer and explanation
Correct answer: B
Explanation
Spanner is the most appropriate database solution for this scenario because it is a fully managed, globally distributed relational database that provides strong consistency, high availability, and seamless horizontal scalability. These features align perfectly with the requirements for transactional financial data, such as minimal operational overhead, automatic failover, and the ability to handle growing workloads.
- A. Incorrect.
Cloud SQL is a managed relational database service that supports MySQL, PostgreSQL, and SQL Server. While it provides high availability and strong consistency, it does not scale horizontally as effectively or provide the same level of global availability and automatic sharding as Spanner.
- B. Correct.
Spanner is a globally distributed and horizontally scalable relational database with strong consistency, high availability, and automatic failover. It is designed for transactional workloads and eliminates operational overhead, making it the ideal solution for this scenario.
- C. Incorrect.
BigQuery is a data warehouse solution optimized for analytical workloads, not transactional workloads. It is not suitable for storing transactional financial data requiring strong consistency and high availability.
- D. Incorrect.
Cloud Firestore is a NoSQL database designed for application backends and real-time synchronization. While it supports high availability, it does not offer the relational database features or strong consistency required for transactional financial data.