Google Cloud Associate Data Practitioner — Question 63

You work for a global financial services company that trades stocks 24/7. You have a Cloud SGL for PostgreSQL user database. You need to identify a solution that ensures that the database is continuously operational, minimizes downtime, and will not lose any data in the event of a zonal outage. What should you do?

Answer options

• A. Continuously back up the Cloud SGL instance to Cloud Storage. Create a Compute Engine instance with PostgreSCL in a different region. Restore the backup in the Compute Engine instance if a failure occurs.
• B. Create a read replica in another region. Promote the replica to primary if a failure occurs.
• C. Configure and create a high-availability Cloud SQL instance with the primary instance in zone A and a secondary instance in any zone other than zone A.
• D. Create a read replica in the same region but in a different zone.

Correct answer: C

Explanation

Option C is the correct choice because configuring a high-availability Cloud SQL instance ensures continuous operation and minimizes downtime by having a secondary instance ready to take over in a different zone. Option A, while it provides a backup solution, does not offer the immediacy needed for continuous operation. Option B's read replica in another region may not be as quick to promote, and Option D does not address zonal outages effectively since both instances are in the same region.