Exam Professional Cloud Database Engineer topic 1 question 49 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 49
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

A. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
B. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
D. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.

Show Suggested Answer

Suggested Answer: C 🗳️

by chelbsik at Dec. 25, 2022, 10:48 a.m.

Comments

Submit Cancel

dynamic_dba

10 months, 3 weeks ago

C. D might be possible but it’s a lot of effort to migrate to a different platform. Eliminate D. A does not mention HA. Eliminate A. B says to take periodic backups which doesn’t support an RTO/RPO of 30 minutes. The best answer is deploy an HA configuration and have a read replica you could promote to the primary in a different region. C is the best answer.

upvoted 4 times

...

GCP72

1 year, 1 month ago

Selected Answer: C

C is the correct answer

upvoted 3 times

...

pk349

1 year, 1 month ago

C: Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote ***** the read replica as the primary node for disaster recovery.

upvoted 1 times

...

chelbsik

1 year, 1 month ago

Selected Answer: C

I'll go with C

upvoted 1 times

...