A financial services institution is architecting a centralized enterprise data platform on Google Cloud to support mission-critical risk analytics and regulatory reporting. The data platform must satisfy the following technical and governance requirements: Provide a 99.99% availability Service Level Agreement (SLA) for core query processing. Enforce advanced security and compliance controls, including Cloud External Key Manager (Cloud EKM) integration and multi-region disaster recovery with automated data replication failover. Support autoscaling compute capacity with baseline workload predictability by leveraging 3-year Committed Use Discounts (CUDs). Provide cross-project reservation sharing and centralized workload management across multiple business units. Which BigQuery Edition and capacity configuration should you select to meet these requirements?

BigQuery Enterprise Plus Edition configured with autoscaling reservations and 3-year capacity commitments: ### What BigQuery Enterprise Plus Edition Is **BigQuery Enterprise Plus Edition** is Google Cloud's highest-tier analytical compute offering, engineered for mission-critical workloads that demand the highest levels of performance, availability, enterprise governance, and regulatory compliance. ### How It Meets the Requirements - **99.99% Availability SLA**: Enterprise Plus delivers a high-availability **99.99% uptime SLA**, compared to the standard 99.9% SLA available on lower editions. - **Advanced Compliance & Security**: It supports advanced governance capabilities, including **Cloud External Key Manager (Cloud EKM)**, multi-region disaster recovery failover, FedRAMP High compliance, and fine-grained data protection. - **Cost Predictability via CUDs**: Enterprise Plus supports **1-year and 3-year Committed Use Discounts (CUDs)** for baseline capacity, allowing organizations to reserve slot commitments at discounted rates while using autoscaling for burst workloads. - **Centralized Capacity Management**: It enables organization-level reservations, slot sharing across multiple projects, and reservation assignments to isolate or share compute resources across business units. ### Key Advantages and Capabilities - **Disaster Recovery**: Native cross-region continuous data replication and managed failover capabilities. - **Enhanced Performance**: Accelerated compute performance tier with expanded maximum memory and processing capacity per slot. - **Flexible Scaling**: Dynamic autoscaling slots layered on top of baseline committed slots to optimize price-performance. - **Enterprise Governance**: Integrated support for Column-level access control, Data Masking, VPC Service Controls, and Cloud EKM. ### Why This Is Optimal Only the **Enterprise Plus Edition** combines a 99.99% uptime SLA, multi-region disaster recovery, and Cloud EKM security with the financial optimization of multi-year capacity commitments.

Evaluate Select Bigquery Editions Workloads | professional-cloud-data-engineer

Evaluate Select Bigquery Editions Workloads

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

A financial services institution is architecting a centralized enterprise data platform on Google Cloud to support mission-critical risk analytics and regulatory reporting. The data platform must satisfy the following technical and governance requirements:

Provide a 99.99% availability Service Level Agreement (SLA) for core query processing.
Enforce advanced security and compliance controls, including Cloud External Key Manager (Cloud EKM) integration and multi-region disaster recovery with automated data replication failover.
Support autoscaling compute capacity with baseline workload predictability by leveraging 3-year Committed Use Discounts (CUDs).
Provide cross-project reservation sharing and centralized workload management across multiple business units.

Which BigQuery Edition and capacity configuration should you select to meet these requirements?

BigQuery Enterprise Edition configured with baseline commitments and multi-region failover replication

BigQuery on-demand analysis pricing model configured with physical storage billing and CMEK

BigQuery Standard Edition configured with autoscaling reservations and 3-year capacity commitments

BigQuery Enterprise Plus Edition configured with autoscaling reservations and 3-year capacity commitments

Professional Cloud Data Engineer

Evaluate Select Bigquery Editions Workloads

Related questions