To build a data pipeline that ingests, transforms, and loads data into BigQuery for analytics, which combination of GCP services would be the most efficient for both real-time and batch processing?
Choose an answer
Tap an option to check your answer.
Correct answer: Dataflow, Pub/Sub, BigQuery.
Why this is the answer
*The most efficient combination of GCP services for building a data pipeline that handles both real-time and batch processing, and loads data into BigQuery for analytics, is Dataflow, Pub/Sub, and BigQuery. Dataflow is a fully managed service that excels in transforming data in both batch and stream processing modes. It integrates seamlessly with Pub/Sub, which provides a reliable and scalable platform for real-time messaging and event ingestion. BigQuery then acts as a highly efficient data warehouse for analytics, capable of processing massive datasets. This trio of services offers a complete solution that covers all aspects of a data pipeline, from ingestion through transformation to analysis. Other combinations mentioned either lack real-time processing capabilities, do not specialize in data transformation, or are not as streamlined and efficient for this specific purpose.*
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed