PROFESSIONAL-DATA-ENGINEER · Question #212
PROFESSIONAL-DATA-ENGINEER Question #212: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
Question
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?
Options
- AOrganize your data in a single table, export, and compress and store the BigQuery data in Cloud Storage.
- BOrganize your data in separate tables for each month, and export, compress, and store the data in Cloud Storage.
- COrganize your data in separate tables for each month, and duplicate your data on a separate dataset in BigQuery.
- DOrganize your data in separate tables for each month, and use snapshot decorators to restore the table to a time prior to the corruption.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.