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…

Question

Options

• 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
• 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

• A
  7% (3)
• B
  12% (5)
• C
  78% (32)
• D
  2% (1)

Explanation

Explanation/Reference: highly available = multi-regional: https://cloud.google.com/bigquery/docs/locations recovery strategy of this data that minimizes cost = point-in-time snapshot: https://cloud.google.com/solutions/bigquery-data-warehouse#backup-and-recovery

No community discussion yet for this question.