Google Cloud Professional Cloud Database Engineer — Question 140

Your company is developing a 24/7, global, real-time analytics platform that needs to store and process large amounts of versioned time-series data. You need to design a platform that is highly scalable to accommodate traffic spikes and ensure high availability for mission-critical operations. What should you do?

Answer options

• A. Implement a single-cluster Bigtable instance with autoscaling enabled and row key design.
• B. Implement a multi-cluster Bigtable instance with autoscaling enabled and optimal schema design.
• C. Implement a multi-cluster Bigtable instance across multiple regions with replication.
• D. Implement AlloyDB for PostgreSQL to handle the analytical workload using read replica.

Correct answer: C

Explanation

The correct answer is C because a multi-cluster Bigtable instance across multiple regions with replication ensures both high availability and scalability, crucial for a global system handling real-time analytics. Option A and B do not provide sufficient redundancy and scalability across regions, and option D is not optimized for time-series data handling.