Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are leveraging Bigtable to support a real-time application characterized by a substantial mixture of read and write operations. Recently, an additional requirement has emerged necessitating the execution of an analytical job every hour to compute specific statistics for the entire database. It is imperative to maintain the reliability and performance of both the production application and the newly introduced analytical workload. What is the optimal approach to achieve this?
Explanation:
The correct answer is C. When using a single cluster to run a batch analytics job alongside an application that performs a mix of reads and writes, the large batch job can slow things down for the application's users. With Bigtable replication, you can use app profiles with single-cluster routing to route batch analytics jobs and application traffic to different clusters. This ensures that batch jobs do not affect the performance of your production application's users. Adding a second cluster and using single-cluster routing allows you to isolate workloads efficiently.