Google
PROFESSIONAL-DATA-ENGINEER · Question #367
You have 100 GB of data stored in a BigQuery table. This data is outdated and will only be accessed one or two times a year for analytics with SQL. For backup purposes, you want to store this data to
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #367. The question stem and answer options stay visible for context.
Submitted by andres_qro· Mar 30, 2026Designing data processing systems
Question
You have 100 GB of data stored in a BigQuery table. This data is outdated and will only be accessed one or two times a year for analytics with SQL. For backup purposes, you want to store this data to be immutable for 3 years. You want to minimize storage costs. What should you do?
Options
- A
- Create a BigQuery table clone.
- B
- Create a BigQuery table snapshot.
- C
- Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
- D
- Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
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.
Topics
#BigQuery export#Cloud Storage Archive#Data lifecycle management#Cost optimization