Google Exam Professional Data Engineer Topic 4 Question 76 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 76
Topic #: 4

[All Professional Data Engineer Questions]

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table?

ASet the BigQuery dataset to be regional. In the event of an emergency, use a point-in-time snapshot to recover the data.

BSet the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.

CSet the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.

DSet the BigQuery dataset to be multi-regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.

Show Suggested Answer

Suggested Answer: C

by Lorrie at Jan 23, 2024, 01:07 AM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tamar

7 days ago

Hmm, I'm not sure. Option A seems a bit risky - relying solely on point-in-time snapshots could be problematic. I think I'll go with option B or D.

upvoted 0 times

...

Julieta

19 days ago

I'm leaning towards option D. Multi-regional storage with scheduled backups seems like the safest bet to protect against any outages or data loss.

upvoted 0 times

...

1 months ago

I think option A is the best choice. Regional setting with point-in-time snapshot for recovery sounds efficient.

upvoted 0 times

...