Q: 9
You are designing a fault-tolerant architecture to store data in a regional BigOuery dataset. You need
to ensure that your application is able to recover from a corruption event in your tables that occurred
within the past seven days. You want to adopt managed services with the lowest RPO and most cost-
effective solution. What should you do?
Options
Discussion
Option C here, as time travel is built-in for seven days and does not add extra costs. Clean and straightforward question.
Option C Had something like this in a mock and C was right for 7-day recovery, not D.
C , time travel is built in and covers exactly the 7 day window with no extra cost or maintenance. Snapshots (D) are only needed if you want more than 7 days. Anyone see a catch here?
C no doubt. Time travel is automatic for 7 days and doesn't bump up costs like daily snapshots. Pretty straightforward here.
For me, C makes more sense here. Time travel is built-in and covers the past 7 days, so you don't pay extra like with daily snapshots (D). D is tempting if you want longer retention, but for just 7 days, C's lower cost wins. Anyone see it differently?
C here. Time travel fits since it lets you query data as of any point in the past 7 days, no manual backups or extra cost. D would only be needed for longer retention, I think. If anyone disagrees, let me know.
Had something like this in a mock, went with C. Time travel fits the 7-day rollback, no extra cost or config.
C makes sense here since BigQuery time travel lets you query the state of your data from anytime within the last 7 days, which matches exactly what they're asking for. No extra cost or management compared to doing manual snapshots (D), which you'd only need if >7 days was required. Pretty sure this is what Google wants, but happy to hear if I'm missing anything.
C I encountered exactly similar question in my exam. Time travel covers the 7 days window without extra setup or cost, so that's the most efficient pick here.
C is the way to go, since BigQuery time travel lets you access data up to 7 days back without extra work or costs. Snapshots (D) cost more and don't give you anything extra within that window. Pretty confident unless I'm missing something.
Be respectful. No spam.
