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 analysis
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
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.
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
#Cloud Storage#BigQuery#multi-format data#high availability design