Google
PROFESSIONAL-DATA-ENGINEER · Question #207
You are designing a cloud-native historical data processing system to meet the following conditions: The data being analyzed is in CSV, Avro, and PDF formats and will be accessed by multiple…
The correct answer is C. Store the full dataset in BigQuery, and store a compressed copy of the data in a Cloud Storage bucket. Explanation/Reference: Keep this ratio as 80% warm and 20% active. Explanation/Reference:
Submitted by dimitri_ru· Mar 30, 2026Designing data processing systems
Question
You are designing a cloud-native historical data processing system to meet the following conditions: The data being analyzed is in CSV, Avro, and PDF formats and will be accessed by multiple analysis tools including Cloud Dataproc, BigQuery, and Compute Engine. A streaming data pipeline stores new data daily. Peformance is not a factor in the solution. The solution design should maximize availability. How should you design data storage for this solution?
Options
- AStore and process the entire dataset in BigQuery.
- BStore and process the entire dataset in Cloud Bigtable.
- CStore the full dataset in BigQuery, and store a compressed copy of the data in a Cloud Storage bucket.
- DStore the warm data as files in Cloud Storage, and store the active data in BigQuery.
How the community answered
(47 responses)- A4% (2)
- B15% (7)
- C70% (33)
- D11% (5)
Explanation
Explanation/Reference: Keep this ratio as 80% warm and 20% active. Explanation/Reference:
Topics
#Cloud Storage#BigQuery#multi-format data#high availability design
Community Discussion
No community discussion yet for this question.