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 European healthcare organization is migrating its PostgreSQL-based patient records database to Google Cloud. To comply with regional healthcare regulations and corporate data sovereignty mandates, the architecture must enforce the following requirements:
europe-west1 and europe-west4.Which combination of Google Cloud database configurations and governance controls should the organization implement?
europe multi-region configuration, rely on Google-managed default encryption keys, and configure Cloud Audit Logs to alert administrators if resources are created outside the EU.This approach uses Cloud Spanner in a broad multi-region configuration alongside Google Cloud's default encryption at rest and Cloud Audit Logs for post-deployment monitoring.
europe-west1 and europe-west4 boundary mandated by policy.The organization needed a globally consistent relational database across broad European locations, did not require strict pinning to two specific regions, and accepted Google-managed encryption with detective monitoring rather than preventive controls.
europe-west1 with a VPC Service Controls perimeter around the project, and configure Customer-Supplied Encryption Keys (CSEK) stored on-premises to encrypt the database disks.This option deploys AlloyDB for PostgreSQL inside a single region, wraps the project in a VPC Service Controls security perimeter, and attempts to use Customer-Supplied Encryption Keys (CSEK) for disk encryption.
europe-west1 omits disaster recovery replication to europe-west4.The workload ran self-managed PostgreSQL on Compute Engine VMs requiring CSEK disk encryption and API-level exfiltration protection rather than managed database CMEK with regional Cloud HSM and location-restriction policies.
europe-west1 with automated backups stored in the eu multi-region, enable Access Approval, and configure Cloud External Key Manager (Cloud EKM) with keys hosted in a US-based third-party KMS.This option places a Cloud SQL for PostgreSQL instance in europe-west1, directs backups to the broader eu multi-region, enables Access Approval, and integrates Cloud External Key Manager (Cloud EKM) with keys hosted in the United States.
eu multi-region allows data to reside in European data centers outside the two specifically approved regions (europe-west1 and europe-west4).The compliance policy required keeping keys completely outside Google's infrastructure in a US-hosted third-party KMS, allowed backups anywhere in the EU multi-region, and focused on gating Google support access rather than restricting developer provisioning regions.
europe-west4, enforce a Resource Locations organization policy constraint allowing only europe-west1 and europe-west4, and configure CMEK using Cloud HSM keys in those regions.This solution combines Cloud SQL for PostgreSQL regional and cross-region replication controls with Organization Policy Service guardrails and Customer-Managed Encryption Keys (CMEK) backed by Cloud HSM. Together, these services enforce strict data locality, prevent unauthorized deployments, and ensure customer-controlled cryptographic protection inside dedicated hardware.
europe-west1 and a cross-region read replica in europe-west4, data at rest and custom backup locations can be explicitly pinned to those two approved regions.constraints/gcp.resourceLocations) at the organization or folder level restricts where supported Google Cloud resources can be created. By specifying only europe-west1 and europe-west4 in the allowlist, engineers are blocked at deployment time from creating instances, replicas, or keys elsewhere.Unlike detective monitoring or multi-region configurations that may span unapproved jurisdictions, this architecture enforces preventive technical boundaries across compute, storage, backups, and hardware-backed encryption keys.
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