Examkin

Question

Difficulty: EasyManaging Storage and Database Solutions

Your production Cloud SQL for PostgreSQL database instance is experiencing high CPU utilization caused by heavy analytical reporting queries. You need to offload this read-only query workload from the primary database instance with minimal operational effort. What should you do?

  1. Create a Cloud SQL read replica and route the analytical reporting queries to the replica instance.Answer
  2. B
    Migrate the analytical reporting data to a Cloud Bigtable cluster to execute complex relational SQL join queries.
  3. C
    Change the storage class of the primary Cloud SQL instance data disks to Archive Storage.
  4. D
    Assign the primitive Owner role to all reporting user accounts to grant elevated execution priority on the database.

Answer

Create a Cloud SQL read replica and route the analytical reporting queries to the replica instance.
Creating a Cloud SQL read replica provides a read-only copy of the primary database. Directing heavy analytical reporting queries to the read replica offloads CPU consumption from the primary instance with minimal operational effort.

Step-by-Step Solution

1
Identify the performance bottleneck on the primary Cloud SQL instance.
Heavy read-only analytical queries are consuming CPU resources on the primary database.
Separating read workloads from write operations reduces resource contention on the primary instance.
2
Select the appropriate Cloud SQL feature to scale read operations.
Deploy a Cloud SQL read replica in the same or another region.
Cloud SQL read replicas replicate data asynchronously from the primary instance and serve read-only queries.
3
Configure the reporting application to connect to the replica.
Reporting queries are directed to the read replica's IP address.
This offloads read traffic from the primary instance with minimal configuration overhead.

Key Concept

Cloud SQL Read Replicas for Read Scaling
Estimated Time:1m 0s
Rate this question

Topics

Managing Storage and Database Solutions