PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #25
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
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
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,
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.