Google Professional Data Engineer Question 33
Select 3Google Cloud PlatformYour organization is building a distributed e-commerce platform on Google Cloud. The platform requires high availability to handle a large number of concurrent users, but it also needs to ensure transactional integrity for operations like inventory updates and payments. Which approach would you take to meet these requirements?
- A
Use Cloud Spanner to ensure global ACID compliance and high availability.
- B
Use Cloud SQL for ACID compliance, and implement a failover replica for high availability.
- C
Use Bigtable for high availability and implement application-level logic to manage ACID compliance.
- D
Use Firestore in Native mode for strong consistency and multi-region replication.
- E
Use a combination of Pub/Sub and BigQuery for transactional integrity and availability.
Show answer and explanation
Correct answers: A, B, D
Explanation
This question tests your ability to make architecture decisions balancing ACID compliance and availability based on Google Cloud's managed services. Cloud Spanner, Cloud SQL with failover, and Firestore in Native mode are all valid solutions for ensuring transactional integrity (ACID compliance) and high availability, depending on the specific system requirements. Bigtable lacks native ACID support, and Pub/Sub with BigQuery is not designed for transactional use cases.
- A. Correct.
Cloud Spanner provides global ACID compliance and high availability, making it a suitable choice for systems requiring both transactional integrity and scalability.
- B. Correct.
Cloud SQL supports ACID transactions and can be configured with a failover replica to provide high availability, though it may not scale as well as other options.
- C. Incorrect.
Bigtable is highly available and scalable but does not natively support ACID transactions, so relying on it would require significant application-level development to implement transactional integrity.
- D. Correct.
Firestore in Native mode provides strong consistency, multi-region replication, and is designed for high availability. It is suitable for scenarios requiring both consistency and availability.
- E. Incorrect.
Pub/Sub is a messaging service and BigQuery is an analytics platform; neither is designed to natively handle transactional integrity, making this combination unsuitable for the described scenario.