You use BigQuery as your centralized analytics platform. New data is loaded every day, and an ETL pipeline modifies the original data and prepares it for the final users. This ETL pipeline is regularly modified and can generate errors, but sometimes the errors are detected only after 2 weeks. You need to provide a method to recover from these errors, and your backups should be optimized for storage costs. How should you organize your data in BigQuery and store your backups?
A) Organize your data in a single table, export, and compress and store the BigQuery data in Cloud Storage.
B) Organize your data in separate tables for each month, and export, compress, and store the data in Cloud Storage.
C) Organize your data in separate tables for each month, and duplicate your data on a separate dataset in BigQuery.
D) Organize your data in separate tables for each month, and use snapshot decorators to restore the table to a time prior to the corruption.
Correct Answer:
Verified
Q90: You are operating a Cloud Dataflow streaming
Q91: You are managing a Cloud Dataproc cluster.
Q92: You are a retailer that wants to
Q93: The marketing team at your organization provides
Q94: You have developed three data processing jobs.
Q96: You are running a pipeline in Cloud
Q97: As your organization expands its usage of
Q98: You need to create a data pipeline
Q99: You work for a manufacturing company that
Q100: You have historical data covering the last
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents