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

Wilburn

1 months ago

Time to channel my inner data-wrangling superhero! These options are like a buffet of backup strategies. I'll take one of each, please!

upvoted 0 times

...

Sylvie

1 months ago

Definitely option D. Why not go all-out and get the best of both worlds? Multi-regional storage and scheduled backups - can't beat that for high availability and peace of mind.

upvoted 0 times

Vilma

5 days ago

Scheduled backups are crucial for minimizing data loss in case of emergencies.

upvoted 0 times

...

Lisha

10 days ago

Definitely, option D seems like the most reliable choice for minimizing cost and maximizing data availability.

upvoted 0 times

...

Stevie

16 days ago

I agree, having both multi-regional storage and scheduled backups is a great way to ensure high availability of the data.

upvoted 0 times

...

Susana

16 days ago

I think setting the dataset to be multi-regional is a smart move for data redundancy.

upvoted 0 times

...

Daren

17 days ago

I agree, option D seems like the most reliable choice for high availability.

upvoted 0 times

...

Laurene

20 days ago

Option D sounds like the best choice. Multi-regional storage and scheduled backups seem like a solid strategy.

upvoted 0 times

...

Tamar

2 months 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

Eun

14 days ago

I think both options B and D provide a good balance of availability and cost efficiency.

upvoted 0 times

...

Yvette

16 days ago

I'm leaning towards option D. Having scheduled backups seems like a good idea.

upvoted 0 times

...

Rebecka

21 days ago

I agree, option A does seem risky. I think option B is a safer choice.

upvoted 0 times

...

Julieta

2 months 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

Elroy

18 days ago

Definitely, having a solid backup and recovery strategy is crucial for maintaining data availability.

upvoted 0 times

...

Teri

25 days ago

It's always better to be safe than sorry when it comes to data storage and recovery.

upvoted 0 times

...

Yoko

1 months ago

I agree, having scheduled backups also ensures that you have recent copies of the data in case of emergencies.

upvoted 0 times

...

Paris

1 months ago

Option D sounds like a good choice. Multi-regional storage provides redundancy in case of failures.

upvoted 0 times

...

Carisa

2 months ago

Option B looks like the best choice to me. Keeping the dataset regional and creating scheduled backups seems like a cost-effective way to ensure high availability and easy recovery.

upvoted 0 times

Mirta

1 months ago

I agree, setting the dataset to be regional and creating scheduled backups is a good strategy to minimize cost while ensuring data availability.

upvoted 0 times

...

Jody

2 months ago

Option B looks like the best choice to me. Keeping the dataset regional and creating scheduled backups seems like a cost-effective way to ensure high availability and easy recovery.

upvoted 0 times

...

Anglea

2 months ago

I agree, setting the dataset to be regional and creating scheduled backups is a good strategy to minimize cost while ensuring data availability.

upvoted 0 times

...

Ilda

2 months ago

Option B looks like the best choice to me. Keeping the dataset regional and creating scheduled backups seems like a cost-effective way to ensure high availability and easy recovery.

upvoted 0 times

...