PDE Maintaining and Automating Data Workloads Practice Question
You are building a data pipeline that runs daily batch jobs on Dataproc, then loads results into BigQuery. You want to orchestrate the entire workflow, including dependencies between steps, retries, and monitoring. Which Google Cloud service is most appropriate?
⚠ Common exam trap
Many candidates confuse orchestration services: candidates often pick Cloud Workflows because it sounds like a workflow tool, but the exam expects you to recognize that Airflow-based Cloud Composer is the standard for data pipeline orchestration with dependencies and retries.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Cloud Composer
Cloud Composer is the most appropriate service because it is a fully managed Apache Airflow service that provides workflow orchestration with DAGs, dependency management, retries, scheduling, and monitoring. It natively integrates with Dataproc and BigQuery operators, allowing you to define the entire pipeline as code. This matches the requirement for orchestrating a multi-step daily batch workflow.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Cloud Scheduler
Why it's wrong here
Cloud Scheduler only triggers jobs on a cron timetable; it cannot model step dependencies, retries, or monitoring across Dataproc and BigQuery. It is tempting because it correctly handles the daily trigger, which would be the right choice for firing a single job on a schedule.
- ✓
Cloud Composer
Why this is correct
Cloud Composer, built on Apache Airflow, models the pipeline as a directed acyclic graph, so Dataproc job dependencies, retries and monitoring are orchestrated natively. It satisfies the stem's requirement for cross-service workflow orchestration, which BigQuery scheduled queries alone cannot provide.
- ✗
Cloud Workflows
Why it's wrong here
Cloud Workflows orchestrates API calls and service chains, but lacks native operators for Dataproc job submission and BigQuery load dependencies with retries. Cloud Composer (managed Airflow) provides those batch DAG operators, which is why it is the correct choice for this pipeline.
- ✗
Dataflow
Why it's wrong here
Dataflow executes Apache Beam pipelines for data transformation, not orchestration of external Dataproc jobs and BigQuery loads with dependencies. It is tempting because it processes and moves data, which would be the right choice for building the transformation pipeline itself rather than coordinating steps.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PDE question from scratch — 747 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Google Cloud exam blueprint
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.