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 planning a disaster recovery (DR) and high-availability architecture for its mission-critical BigQuery analytics warehouse to meet stringent business SLAs:
Which storage and operational architecture correctly satisfies these business and recovery requirements?
This architecture pairs cross-region dataset replication and failover reservations across two distinct single regions (us-central1 and us-east1) with BigQuery's built-in time travel and fail-safe retention mechanisms to achieve comprehensive disaster recovery.
US multi-region) store data within a single region in that geography and do not provide automated regional redundancy. Pairing two distinct regions like us-central1 and us-east1 avoids shared failure domains while strictly complying with US data residency.This design directly maps the operational SLAs to native Google Cloud features: cross-region replication handles physical infrastructure disasters, while the combined 14-day time travel and fail-safe retention covers long-tail logical corruption.
This design uses a single-region dataset (us-central1), transfers data to the US multi-region using BigQuery Data Transfer Service, and executes scheduled table exports to Cloud Storage Coldline every 14 days.
us-central1) with a multi-region (US) that encompasses that same region introduces shared fate risks. If us-central1 suffers a catastrophic outage, the multi-region storage located in the same physical infrastructure can also be impacted.The business objective allowed a multi-day RTO/RPO and was focused purely on low-cost cold data archiving rather than disaster recovery high availability.
This option places the warehouse in us-central1, uses standard 7-day time travel, and attempts to manage cross-region disaster recovery by streaming BigQuery CDC logs into a Cloud Storage dual-region bucket configured with Turbo Replication.
The primary goal was raw object storage disaster recovery for unstructured data lake files with a 15-minute RPO SLA.
This option relies entirely on a BigQuery US multi-region dataset and attempts to extend the dataset's time travel window to 14 days to meet the RPO and data corruption recovery requirements.
US or EU) does not provide cross-region replication or automated regional disaster redundancy; data is stored across zones within a single primary region in that geographic area.The workload only needed protection against single-zone failures and all table corruption issues were guaranteed to be discovered and fixed within 7 days.
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