Exam Professional Cloud Database Engineer topic 1 question 137 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 137
Topic #: 1

[All Professional Cloud Database Engineer Questions]

Your rapidly growing ecommerce company is migrating their analytics workloads to AlloyDB for PostgreSQL. You anticipate a significant increase in reporting queries as the business scales. You need a read pool strategy to scale your analytics operations in anticipation of future growth while minimizing costs. What should you do?

A. Direct all complex, long-running analytics queries to the primary instance, and only use read pools for short, frequent reports.
B. Change the instance sizes of the read nodes in the read pool.
C. Begin with minimal read pools and iteratively expand or shrink them based on real-time load monitoring to optimize resource allocation.
D. Assign all reporting queries to a single, large read pool to maximize the combined compute resources available for analytics.

Show Suggested Answer

Suggested Answer: C 🗳️

by WOOJONE at May 29, 2025, 12:46 a.m.

Comments

Submit Cancel

c3815ba

2 weeks, 6 days ago

Selected Answer: C

AlloyDB for PostgreSQL supports read pools, which are read-only replicas designed to handle analytical workloads like reporting and business intelligence queries. These help offload read pressure from the primary instance and scale horizontally. Why Option C is correct: • Cost-efficient: You avoid overprovisioning and only scale when needed. • Scalable: AlloyDB allows dynamic scaling of read pool nodes. • Performance-aware: You can use Cloud Monitoring and query performance stats to determine when to scale. • Best practice: Google Cloud recommends starting small and adjusting based on observed load to balance performance and cost.

upvoted 1 times

...

MikeFR

2 months, 1 week ago

Selected Answer: C

adapt the figure when needed ... not before

upvoted 1 times

...