Question

A financial services company stores critical transactional data in a BigQuery dataset located in the us-central1 region. Compliance requires that the company be able to recover the dataset with a Recovery Point Objective (RPO) of no more than 4 hours if the entire region becomes unavailable. The team wants a solution that is automated, cost-effective, and requires minimal ongoing operational overhead. Which approach should they implement?

Accepted Answer

Configure a scheduled query or scheduled data transfer that copies the dataset to a second dataset in a different region at least every 4 hours.

Answer

Rely on BigQuery's built-in 7-day time travel feature to restore the dataset after a regional outage.

Answer

Enable multi-region storage by moving the dataset to the 'US' multi-region location, which guarantees automatic failover with zero RPO.

Answer

Export the dataset to a single-region Cloud Storage bucket in us-central1 nightly using a batch extract job.