Google Professional Cloud Database Engineer Question 67
Single answerGoogle Cloud PlatformYour company needs to build a real-time recommendation engine to provide personalized offers to customers. The solution must handle high transaction rates, ensure low-latency responses, and allow for flexible schema updates as new types of data are introduced. Which Google Cloud database solution is most appropriate for this use case?
- A
Cloud Spanner
- B
Cloud Bigtable
- C
Firestore
- D
Cloud SQL
Show answer and explanation
Correct answer: B
Explanation
Cloud Bigtable is the most appropriate database solution for a real-time recommendation engine because it is designed to handle high-throughput, low-latency analytics workloads. It supports a flexible schema, which is crucial for adapting to new data types as the recommendation engine evolves. Other options, such as Cloud Spanner, Firestore, and Cloud SQL, either lack the scalability, low-latency performance, or schema flexibility required for this use case.
- A. Incorrect.
Cloud Spanner is a horizontally scalable, strongly consistent relational database service. While it supports high transaction rates, it is not optimized for low-latency queries required by real-time recommendation engines, and its schema is not as well-suited for frequent updates.
- B. Correct.
Cloud Bigtable is an ideal choice for real-time analytics and workloads like recommendation engines. It is highly scalable, provides low-latency reads and writes, and supports a flexible schema, making it well-suited for this use case.
- C. Incorrect.
Firestore is suitable for applications requiring a flexible schema and real-time data synchronization. However, it is not optimized for high transaction rates and low-latency analytics as required for a recommendation engine.
- D. Incorrect.
Cloud SQL is a managed relational database service, but it is not designed to handle high transaction rates and low-latency requirements at scale. It also lacks the flexibility needed for schema updates in this scenario.