Google Professional Cloud Database Engineer Question 50
Single answerGoogle Cloud PlatformYour company is building a global e-commerce platform that requires a database solution to handle millions of daily transactions with low latency, high availability, and strict security requirements. The database must support multi-region replication, automatic failover, and encryption of data at rest and in transit. Which Google Cloud database solution would be the most suitable for this use case?
- A
Cloud SQL with MySQL
- B
Bigtable
- C
Firestore in Native Mode
- D
Spanner
Show answer and explanation
Correct answer: D
Explanation
Spanner is the most suitable database solution for a global e-commerce platform due to its ability to provide strong consistency, horizontal scalability, and global availability. It supports multi-region replication, automatic failover, and robust security features such as encryption of data at rest and in transit. These capabilities directly align with the requirements of the scenario, such as handling millions of transactions globally with low latency and high availability.
- A. Incorrect.
Cloud SQL with MySQL is a managed relational database service that provides high availability and encryption features. However, it is not designed for global, multi-region replication on its own and may require additional configuration or tools to achieve the required scalability and availability for this use case.
- B. Incorrect.
Bigtable is a highly scalable key-value store designed for low-latency workloads. However, it is not a relational database, lacks support for SQL, and is not ideal for transactional workloads like those required by an e-commerce platform.
- C. Incorrect.
Firestore in Native Mode is an excellent choice for serverless applications and real-time syncing. However, it is not designed for complex transactional workloads or multi-region replication with strict consistency, which makes it unsuitable for this use case.
- D. Correct.
Spanner is a globally distributed relational database service that provides strong consistency, multi-region replication, automatic failover, and encryption of data at rest and in transit, making it ideal for handling global e-commerce platforms with strict security and availability requirements.