nerdexam
GoogleGoogle

PROFESSIONAL-DATA-ENGINEER · Question #293

PROFESSIONAL-DATA-ENGINEER Question #293: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #293. The question stem and answer options stay visible for context.

Submitted by jian89· Mar 30, 2026Ensuring solution quality

Question

You are using BigQuery with a multi-region dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?

Options

  • ASchedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
  • BSchedule a daily copy of the dataset to a backup region.
  • CSchedule a daily BigQuery snapshot of the table.
  • DModify ETL job to load the data into both the current and another backup region.

Unlock PROFESSIONAL-DATA-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#BigQuery#Disaster Recovery#Data Backup#Cost Optimization
Full PROFESSIONAL-DATA-ENGINEER PracticeBrowse All PROFESSIONAL-DATA-ENGINEER Questions