Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Professional Cloud Database Engineer practice bank has an additional 769 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
Your organization is deploying a mission-critical PostgreSQL database using AlloyDB Omni on Google Cloud. The architecture must satisfy the following requirements:
RPO = 0) and automatic failover if a single availability zone fails.RTO) during a regional outage.Which replication and deployment strategy should you implement?
In an all-asynchronous replication setup, the primary database commits transactions locally and immediately acknowledges the client without waiting for any standby node—whether in the same region or a remote region—to receive or write the WAL records.
RPO = 0): Because transactions are confirmed before standby replicas receive them, an abrupt crash or outage in the primary zone can permanently lose recently committed transactions that were still in transit.RPO) and the replay time (RTO) during failover.The workload prioritized maximum write throughput and lowest possible commit latency over strict data durability, and the business could tolerate a non-zero RPO (losing a few seconds of recent transactions) during a zonal outage.
Configuring synchronous replication across multiple regions requires the primary database node to transmit WAL records and wait for commit acknowledgments from standby nodes located in distant geographic regions before confirming each write transaction to the client.
RTT). Waiting for a remote region to acknowledge every write adds tens or hundreds of milliseconds per transaction, drastically reducing write throughput and degrading application responsiveness under heavy load.RPO = 0) during a regional disaster, standard PostgreSQL streaming replication is not optimized for long-haul synchronous commits.The organization required strict zero data loss (RPO = 0) even in the event of a total regional catastrophe and could tolerate significantly higher write latency, or if it adopted a globally distributed consensus database like Cloud Spanner designed specifically for cross-region transactional synchronization.
A hybrid replication architecture combines in-region synchronous replication for high availability (HA) with cross-region asynchronous replication for disaster recovery (DR). In a three-node cluster, the primary node streams Write-Ahead Log (WAL) records synchronously to a nearby standby node in another availability zone within the same region, while asynchronously streaming changes to a remote standby node in a geographically distant region.
RPO = 0) during single-zone outages or primary failures.RTO) if the entire primary region becomes unavailable.Physical distance directly dictates network latency. By restricting synchronous acknowledgment to low-latency intra-region links and using asynchronous streaming across long geographic distances, this design achieves the optimal trade-off between transaction speed, strong local consistency, and multi-region resilience.
A zonal deployment places the database compute instance and its storage—such as a zonal Persistent Disk—inside a single availability zone. Disaster recovery relies solely on periodic disk snapshots copied asynchronously to another region rather than live database replication.
RPO > 0): Scheduled snapshots only capture point-in-time states at fixed intervals. Any transactions committed after the last completed snapshot are lost if the zone or disk fails.RTO): Restoring a database from a snapshot requires provisioning a new VM, creating and hydrating a disk from the snapshot, and performing crash recovery—a process measured in minutes or hours rather than seconds.You were deploying a development, testing, or non-critical workload where lowest cost and maximum zonal write speed matter most, and extended downtime plus hours of potential data loss are acceptable.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated