Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 170

Question

Your e-learning platform runs on a Cloud SQL for PostgreSQL instance (16 VCPUs, 60 GB memory and 1TB SSD) serving users in North America. Your analytics team runs complex reporting queries that often consume 80% of CPU resources, causing slow response times for student transactions during peak hours. Current workload includes 8,000 transactions per second with 60% reads and 40% writes. The reporting queries involve JOIN operations across multiple large tables with millions of rows requiring highly efficient analytical processing. The platform also experiences sudden spikes in analytical reporting demand, requiring an elastic scaling of read capacity. You need to improve the query performance for your analytics team to run their reports efficiently without impacting transactional users. You also need to plan for future traffic growth. What should you do?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Migrate to AlloyDB for PostgreSQL with a 16 vCPU primary instance and enable columnar engine for analytical workloads, using read pools for query isolation. AlloyDB is a managed PostgreSQL-compatible database for demanding transactional and analytical workloads. This option decouples the components so they scale independently and absorb load spikes.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 170