GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #25
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #25: Real Exam Question with Answer & Explanation
The correct answer is C: Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read. See the full explanation below for the reasoning.
Designing and planning a database solution
Question
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
Options
- ADeploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read
- BDeploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and
- CDeploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read
- DDeploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1,
Topics
#Cloud SQL#High Availability#Read Replicas#Multi-Region Deployment#Database Scaling
Community Discussion
No community discussion yet for this question.