PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #175: Real Exam Question with Answer & Explanation

Question

Options

• AUse read replicas for query offloading, configure automatic failover, and test failover procedures
• BVertically scale the primary instance by significantly increasing compute resources, such as
• CIncrease storage size on the existing instance and implement client-side caching for frequently
• DMigrate to a Cloud SQL for PostgreSQL database for better performance during high load.

Explanation

Using read replicas for query offloading combined with automatic failover and tested failover procedures is the correct and most comprehensive answer. Read replicas absorb read-heavy analytics and reporting traffic that typically dominates ecommerce peak loads, directly relieving pressure on the primary instance. Automatic failover ensures high availability during outages, and testing failover procedures validates that the HA setup works before a real incident occurs - minimizing actual downtime. Vertically scaling the primary instance (B) increases capacity but does not distribute read load; it also requires an instance restart which introduces downtime, and vertical scaling has an upper ceiling. Increasing storage and adding client-side caching (C) addresses storage constraints and reduces some database calls, but does not solve compute or query throughput bottlenecks during traffic spikes. Migrating to Cloud SQL for PostgreSQL (D) does not inherently improve performance for MySQL workloads and introduces significant migration risk, testing effort, and potential downtime - it is not an appropriate solution for a performance problem that can be addressed at the infrastructure level.

No community discussion yet for this question.