Topic 1 Question 318

Professional Data Engineer

Topic 1 Question 318
You are using BigQuery with a regional dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?
- Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
- Schedule a daily copy of the dataset to a backup region.
- Schedule a daily BigQuery snapshot of the table.
- Modify ETL job to load the data into both the current and another backup region.
ユーザの投票
コメント(6)
- 正解だと思う選択肢: A
  Option A is the most cost efficient: https://cloud.google.com/blog/topics/developers-practitioners/backup-disaster-recovery-strategies-bigquery
  
  👍 4
  HectorLeon20992024/12/04
- 正解だと思う選択肢: D
  Opción D: Modify ETL job to load the data into both the current and another backup region Evaluación: Ajustar el ETL para escribir en dos tablas (una en la región principal y otra en una región de respaldo) asegura que los datos estén disponibles en ambas ubicaciones casi en tiempo real. Esto garantiza un RPO de menos de 24 horas, ya que las actualizaciones intradía se reflejan en ambas regiones. Aunque podría aumentar los costos de almacenamiento por duplicar los datos, es la solución más efectiva y directa para proteger contra fallos regionales.
  
  👍 2
  joelcaro2024/12/18
- 正解だと思う選択肢: B
  In most cases, it is cheaper to copy a BigQuery dataset to a new region directly rather than exporting it to a Cloud Storage bucket and then loading it into a new BigQuery dataset in the desired region, as you only pay for data transfer costs when copying within BigQuery, while exporting to a bucket incurs additional storage charges for the exported data in Cloud Storage, even if it's only temporary. Key points to consider:
  
  No extra storage cost for copying: When copying a BigQuery dataset to a new region, you only pay for the data transfer cost, not the storage of the data in a separate location.
  
  Storage cost for exporting: Exporting data to a Cloud Storage bucket means you are charged for the storage of that data in the bucket until you delete it, even if you are just temporarily storing it for transfer.
  👍 1
  mdell2024/12/17
シャッフルモード

ユーザの投票

コメント(6)