GoogleGoogle
PROFESSIONAL-DATA-ENGINEER · Question #153
PROFESSIONAL-DATA-ENGINEER Question #153: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.
Submitted by thandi_sa· Mar 30, 2026
Question
You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?
Options
- ATransform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.
- BTransform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.
- CCompress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.
- DCompress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.
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.