Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,132 more like it. Try 10 free: instant score, no account.
A financial services organization is designing a high availability (HA) and disaster recovery (DR) strategy for a mission-critical database in Google Cloud. The system has the following requirements:
Which combination of primary and secondary storage location types should the organization implement?
This configuration represents a single-zone, standard availability deployment where the active database instance and its storage snapshots or backups reside within a single availability zone inside a single region.
The workload were a non-critical development or testing environment where downtime is acceptable and the primary goal is minimizing infrastructure costs rather than providing high availability and disaster recovery.
This approach uses a single-zone primary database paired with scheduled batch exports copied over to an external secondary region on a 24-hour cycle.
The workload consisted of batch analytical datasets or non-transactional archives where up to 24 hours of data loss and hours of restoration time are fully acceptable within business SLAs.
This architecture combines in-region zonal high availability with cross-region disaster recovery replication. The primary database instance processes active read and write transactions while continuously replicating data to two separate locations: a standby instance in a secondary zone within the same primary region, and a read/standby replica located in an entirely different geographic secondary region.

Combining zonal replication for HA with regional replication for DR directly aligns with enterprise best practices for mission-critical databases, matching maximum protection against localized faults without compromising transactional performance.
This configuration implements multi-zone read scaling and local high availability within a single Google Cloud region, where read replicas offload read-heavy traffic across different zones.
The business requirements only specified protection against localized single-zone hardware failures and read scaling within a single geographic region, without demanding disaster recovery protection against regional outages.
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