Exam Associate-Data-Practitioner Topic 2 Question 57 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 57
Topic #: 2
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?

Suggested Answer: D Vote an answer

Comprehensive and Detailed in Depth Explanation:
Why D is correct:Synchronous replication ensures that data is written to both the primary and secondary instances at the same time, minimizing data loss (RPO).
Regional availability (HA) within different zones provides redundancy within the same region, minimizing latency.
Why other options are incorrect:A: Asynchronous replication has a potential for data loss.
B: Multiregion backups are for disaster recovery, not minimizing latency.
C: Hourly backups do not provide the lowest possible RPO.

by Rae at Mar 16, 2026, 07:58 AM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10