Answer-first summary for fast verification
Answer: Enable high availability (HA) for the database to make it regional.
To migrate an on-premises mission-critical PostgreSQL database to Cloud SQL with the ability to withstand a zonal failure with minimal downtime and no transaction loss, the Google-recommended practice is to enable high availability (HA) for the database to make it regional. High availability in Cloud SQL for PostgreSQL automatically provisions a standby instance in a different zone within the same region. In the event of a zonal failure, the standby instance is promoted to primary with minimal downtime, ensuring continuous availability and no loss of transactions. This approach is more reliable and automated compared to manually taking snapshots (option A), building a CDC pipeline (option B), or creating a read replica in another region (option C), which may involve more manual intervention and potential for higher downtime or data loss.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you migrate an on-premises mission-critical PostgreSQL database to Cloud SQL with less than five minutes of downtime during a zonal failure, ensure zero transaction loss, and adhere to Google's recommended practices?
A
Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
B
Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
C
Create a read replica in another region, and promote the read replica if a failure occurs.
D
Enable high availability (HA) for the database to make it regional.
No comments yet.