🔥 40% Off Crucial Exams Memberships — Deal ends today!

3 hours, 1 minute remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

A media-analytics company stores all BigQuery datasets in the us-central1 regional location. A new internal SLA says that reporting queries must keep working with no data loss if one of the zones in that region goes offline. Management will accept a short outage if the entire region fails and does not want to pay for extra pipelines or a second copy of the data. What should you change to meet the SLA?

  • Nightly export the datasets to a dual-region Cloud Storage bucket and re-import them into BigQuery during an outage.

  • Keep the datasets in the current regional location and make no additional changes; BigQuery already provides automatic, zero-RPO replication across zones inside the region.

  • Move all datasets to the multi-regional US location so that data is replicated across multiple regions instead of zones.

  • Set up a BigQuery Data Transfer Service job to copy each table from us-central1 to us-east1 every 15 minutes.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot