You're using Bigtable for a real-time application, and you have a heavy load that is a mix of read and writes. You've recently identified an additional use case and need to perform hourly an analytical job to calculate certain statistics across the whole database. You need to ensure both the reliability of your production application as well as the analytical workload. What should you do?
A) Export Bigtable dump to GCS and run your analytical job on top of the exported files.
B) Add a second cluster to an existing instance with a multi-cluster routing, use live-traffic app profile for your regular workload and batch-analytics profile for the analytics workload. Add a second cluster to an existing instance with a multi-cluster routing, use live-traffic app profile for your regular workload and batch-analytics profile for the analytics workload.
C) Add a second cluster to an existing instance with a single-cluster routing, use live-traffic app profile for your regular workload and batch-analytics profile for the analytics workload. Add a second cluster to an existing instance with a single-cluster routing, use
D) Increase the size of your existing cluster twice and execute your analytics workload on your new resized cluster.

Question

Quizplus · Accepted Answer

Adding a second cluster with multi-cluster routing allows you to separate the workloads, ensuring that the analytical job does not impact the performance of the real-time application. This setup provides reliability for both workloads.

You're Using Bigtable for a Real-Time Application, and You Have