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 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:
Which BigQuery Edition and capacity configuration should you select to meet these requirements?
The On-Demand pricing model charges queries based on the number of bytes scanned during execution, rather than allocating dedicated slot capacity.
The workload consisted of unpredictable, intermittent, or sporadic queries where paying strictly per query byte scanned is more cost-effective than provisioning reservation slots.
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.
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.
BigQuery Enterprise Edition is designed for standard enterprise analytical workloads requiring centralized governance, cross-project reservation sharing, machine learning, and BI Engine integration.
The organization required cross-project reservations, CMEK encryption, and 3-year commitments, but did not require a 99.99% SLA, Cloud EKM, or multi-region automated failover.
BigQuery Standard Edition is an entry-level capacity tier designed for ad-hoc, exploratory analytics and low-complexity data workloads with basic compute and autoscaling needs.
A team required an entry-level, single-project analytical environment for ad-hoc queries with pay-as-you-go billing and no commitments or high-compliance security requirements.
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