Question

Difficulty: MediumManaging Storage and Database Solutions

An operations engineer is managing a Cloud Bigtable cluster that processes high-throughput time-series data from IoT sensors. During daily peak ingestion windows, application latency increases significantly, and Cloud Monitoring indicates that CPU utilization on the Bigtable cluster repeatedly exceeds 80%. The engineer must restore acceptable read/write performance while maintaining cost efficiency and operational monitoring. Which TWO actions should the engineer take to address this issue?

  1. Increase the number of nodes in the Cloud Bigtable cluster or configure a programmatic autoscaling policy based on target CPU utilization.Answer
  2. B
    Migrate the cluster storage tier from SSD to HDD to increase read/write IOPS throughput during peak load.
  3. Create a Cloud Monitoring alerting policy tracking the node CPU utilization metric to proactively trigger capacity adjustments before performance degrades.Answer
  4. D
    Export the time-series data to a Cloud SQL for MySQL instance to handle high-volume write operations with lower latency.

Answer

The engineer should scale out the cluster by increasing node count or enabling autoscaling, and set up Cloud Monitoring alerts on node CPU utilization.
Scaling out node capacity directly mitigates CPU bottlenecks in Cloud Bigtable because processing capacity scales linearly with node count. Combining this with Cloud Monitoring alerting allows administrators to proactively manage workload spikes and maintain low latency.

Step-by-Step Solution

1
Analyze performance metrics for Cloud Bigtable
Identify high CPU utilization (>80%) on cluster nodes as the bottleneck causing elevated latency.
Cloud Bigtable performance depends directly on node count for compute and I/O capacity.
2
Scale Bigtable cluster compute capacity
Add nodes manually or configure an autoscaling policy to distribute load.
Scaling out nodes increases processing power and lowers CPU utilization per node without requiring downtime.
3
Establish proactive monitoring and alerting
Configure Cloud Monitoring alerts for node CPU utilization.
Ensures the operational team is alerted before cluster CPU saturation leads to application latency degradation.

Key Concept

Cloud Bigtable Operational Performance Management and Monitoring
Rate this question