Exam Associate Data Practitioner topic 1 question 70 discussion

Actual exam question from Google's Associate Data Practitioner

Question #: 70
Topic #: 1

[All Associate Data Practitioner Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by n2183712847 at March 6, 2025, 5:32 a.m.

Comments

Submit Cancel

n2183712847

4 months, 1 week ago

Selected Answer: C

The best option is C. HA Cloud SQL. Option C is best: HA is built for continuous ops and zonal failure protection. Option A is incorrect: Backup/restore = downtime. Option B is incorrect: Replica less direct for zonal failover. Option D is incorrect: Read replica no auto-failover for primary. Option C = HA for best uptime.

upvoted 1 times

...