Google Cloud Associate Data Practitioner — Question 76

You have a Cloud SQL for PostgreSQL database that stores sensitive historical financial data. You need to ensure that the data is uncorrupted and recoverable in the event that the primary region is destroyed. The data is valuable, so you need to prioritize recovery point objective (RPO) over recovery time objective (RTO). You want to recommend a solution that minimizes latency for primary read and write operations. What should you do?

Answer options

• A. Configure the Cloud SQL for PostgreSQL instance for multi-region backup locations.
• B. Configure the Cloud SQL for PostgreSQL instance for regional availability (HA) with synchronous replication to a secondary instance in a different zone.
• C. Configure the Cloud SQL for PostgreSQL instance for regional availability (HA) with asynchronous replication to a secondary instance in a different region.
• D. Configure the Cloud SQL for PostgreSQL instance for regional availability (HA). Back up the Cloud SQL for PostgreSQL database hourly to a Cloud Storage bucket in a different region.

Correct answer: D

Explanation

The correct answer is D because it ensures regular backups to a different region, which helps maintain data integrity and supports the RPO requirement. Options A and B do not address the need for backups in a different region, while Option C uses asynchronous replication, which may not meet the same level of data protection as regular backups.