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.
A financial services organization operates multiple production Cloud SQL for PostgreSQL instances in europe-west1 (Belgium). To satisfy disaster recovery and regulatory mandates, the automated scheduled backup architecture must meet the following requirements:
europe-west1.Resource Location Restriction) restricts all resources to europe-west1 and europe-west9 (Paris), prohibiting the use of broad multi-region locations.Which backup configuration should the database architect implement?
europe-west1 inside the centralized backup project, and deploy a cross-region read replica in europe-west9 with a second backup plan attached to the replica.A regional backup vault stores immutable backups redundantly across at least two zones within a single region. Separately, a Cloud SQL cross-region read replica uses asynchronous replication to maintain a live copy of a primary database in another region for read scaling and regional disaster recovery failover.
europe-west1 only protects backups against a single-zone outage. If europe-west1 suffers a catastrophic regional failure, backups stored inside that region become unavailable.europe-west9 improves regional failover speed, asynchronous replication propagates accidental data deletions or corruption from the primary and cannot substitute for isolated, immutable backups.Backups only needed zonal redundancy in europe-west1 and the read replica in europe-west9 was used strictly for asynchronous disaster recovery failover rather than as a target for a backup plan.
europe-west9, and enable backup retention after instance deletion.Standard backups are the built-in, instance-level backup mechanism managed directly by Cloud SQL. Administrators configure retention schedules, backup windows, and storage locations individually on each Cloud SQL instance, and can optionally choose a custom backup location (regional or multi-regional) instead of the default closest multi-region.
Cloud SQL Admin manages both the database and its backups.europe-west9 to satisfy Resource Location Restriction Organization Policies when enhanced backups are not required.The organization only needed per-instance automated backups in a custom EU region within the same workload project and did not require centralized cross-project isolation or immutable enforced retention.
europe-west9 inside the centralized backup project with an enforced retention period, and associate a backup plan created in europe-west1 within that same project.Enhanced backups powered by Google Cloud Backup and DR separate backup storage and governance from source database workloads using backup vaults and backup plans. A cross-region backup vault stores scheduled and on-demand Cloud SQL backups in an explicitly chosen secondary region that is geographically separate from the primary database instance.
europe-west9 ensures that backups are physically isolated from europe-west1. If a catastrophic regional outage affects europe-west1, the backup data in europe-west9 remains intact and accessible for recovery.europe-west1) and the backup vault (europe-west9) comply with the Resource Location Restriction Organization Policy.europe-west1) and in the same project as the target backup vault, while pointing to the remote vault in europe-west9.Backup and DR Admin IAM roles govern the centralized backup project independently from Cloud SQL Admin permissions in workload projects.This architecture is the only approach that combines explicit cross-region residency in europe-west9, immutable vault retention, and cross-project isolation without violating the Organization Policy. Note that if the Cloud SQL instances use Customer-Managed Encryption Keys (CMEK), the key resides in the instance's region, so teams must account for key availability during regional disaster recovery planning.
eu inside the centralized backup project with an enforced retention period, and associate a backup plan created in europe-west1 within that same project.A multi-region backup vault (such as eu, us, or asia) is a Backup and DR container that automatically replicates backup data redundantly across at least two separate regions within a broad continental boundary. It is designed to provide high availability and operational simplicity for organizations that want regional outage resilience without manually pairing specific regions.
eu boundary hold the backup copies. Google automatically manages placement across eligible data centers in the European Union, which fails the mandate to keep backups strictly in europe-west9.europe-west1 and europe-west9, any attempt to provision a vault in the eu multi-region location will be blocked by the policy constraint.The organization had no restriction specifying an exact target country or region within the EU, permitted the eu multi-region in its Organization Policy, and prioritized operational simplicity over explicit regional placement.
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