Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
A financial enterprise is building a data analytics platform on Google Cloud to process highly confidential transaction records subject to strict national data residency mandates. Regulatory compliance requires that all data at rest, data processing workloads, and API traffic termination remain strictly within Belgium (europe-west1), preventing any cross-border data transfer.
Which architectural strategy should the data engineering team implement to satisfy these compliance and data residency requirements?
This architecture combines Google Cloud Organization Policies, localized single-region resource placement in BigQuery and Cloud Storage, and BigQuery regional endpoints to enforce strict data sovereignty and residency boundaries within a single geographic territory.
constraints/gcp.resourceLocations) at the organization or folder level restricts the deployment of all supported storage and compute resources exclusively to europe-west1, blocking non-compliant provisioning attempts.europe-west1 single region ensures data at rest is stored strictly within Belgium. When BigQuery runs queries against or loads data from colocated single-region datasets, the compute execution and temporary shuffle data remain confined to that specific region.bigquery.europe-west1.rep.googleapis.com ensures that TLS sessions terminate inside europe-west1 and prevents API requests or in-transit data from being routed through global entry points outside the regulatory boundary.This configuration provides end-to-end data residency at the resource configuration, query processing, and network transit layers without risking the broader geographic distribution inherent in multi-region or dual-region services.
This option configures a Cloud Storage bucket across the predefined EUR4 dual-region (which pairs Finland and Netherlands or Belgium and Netherlands depending on configuration) with a regional BigQuery dataset in europe-west1, using BigQuery's automatic location detection for queries.
US multi-region) or having logs temporarily stored in global routers.The organization required high availability disaster recovery across two European countries while tolerating cross-border replication between paired data centers.
This configuration sets the Resource Locations Organization Policy and provisions BigQuery and Cloud Storage assets within the EU multi-region location, while routing client traffic through standard global BigQuery API endpoints.
EU multi-region encompasses data centers across multiple European nations. BigQuery and Cloud Storage multi-regions do not guarantee that data at rest or compute jobs remain exclusively within Belgium (europe-west1).EU permit resource creation across any supported European region.The workload was subject only to general European Union data protection regulations that permit data storage and processing anywhere within the European Union boundaries rather than requiring localization within Belgium specifically.
This approach splits the storage and analytics tiers across two separate Google Cloud regions—placing Cloud Storage in Belgium (europe-west1) and BigQuery in the Netherlands (europe-west4)—and uses the BigQuery Data Transfer Service to transfer data between them.
europe-west1 to europe-west4 moves confidential financial records across national borders, directly violating Belgian data residency rules.europe-west4 forces all SQL processing, shuffle operations, and cache storage to occur inside data centers in the Netherlands rather than Belgium.The enterprise operated under a multi-site architecture across the Benelux region where cross-border replication between Belgium and the Netherlands was legally permitted and required for disaster recovery.
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