Multiple Choice
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?
A) Set the BigQuery dataset to be regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
B) Set 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.
C) Set the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
D) Set 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.
Correct Answer:

Verified
Correct Answer:
Verified
Q21: Which of these numbers are adjusted by
Q22: You are designing storage for very large
Q23: You are building a model to make
Q24: You are implementing security best practices on
Q25: You have a requirement to insert minute-resolution
Q27: Your company is currently setting up data
Q28: Which Cloud Dataflow / Beam feature should
Q29: You have a query that filters a
Q30: Which is not a valid reason for
Q31: Your analytics team wants to build a