Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
An enterprise data analytics team needs to build and manage a centralized data pipeline with the following requirements:
Which Google Cloud data orchestration solution should the team select?
Dataproc Workflow Templates provide a lightweight mechanism to define, submit, and manage a directed graph of jobs (such as Spark, PySpark, Hive, and Pig) that execute on managed Dataproc Hadoop/Spark clusters.
gcloud CLI rather than using a full-featured Python workflow orchestration framework.prerequisiteStepIds in YAML/JSON.The requirement was to automate a self-contained sequence of PySpark and Spark SQL jobs that create a temporary Dataproc cluster, process data from Cloud Storage, and shut down the cluster without needing external service orchestration.
Cloud Composer is a fully managed workflow orchestration service built on Apache Airflow. It enables data teams to author, schedule, and monitor end-to-end pipelines using Python to define Directed Acyclic Graphs (DAGs). Cloud Composer provisions and manages the underlying Airflow infrastructure (including web server, scheduler, and workers on Google Kubernetes Engine), giving organizations enterprise-grade orchestration with minimal administrative overhead.
.py), enabling version control via Git, automated testing, and CI/CD deployment workflows.Cloud Composer is the standard enterprise solution for complex, multi-system data pipeline orchestration. While simpler tools exist for single-service automation or lightweight serverless APIs, only Cloud Composer offers the programmatic power, extensive multi-cloud provider ecosystem, and deep Airflow DAG capabilities required for large-scale enterprise data workflows.
BigQuery Scheduled Queries is a built-in feature of BigQuery that automates the periodic execution of SQL queries, such as data manipulation (DML), data definition (DDL), or recurring analytical aggregations, on a regular schedule (e.g., hourly, daily, or custom cron intervals).
The business scenario required a zero-infrastructure way to execute a standalone daily SQL aggregation query that populates a summary table directly inside BigQuery without external dependencies or multi-system coordination.
Workflows is a fully managed, serverless orchestration service in Google Cloud that links together HTTP-based APIs, Google Cloud services (such as Cloud Functions, Cloud Run, and Cloud Run jobs), and external endpoints using a YAML or JSON workflow syntax.
The organization needed a serverless, pay-per-use orchestrator defined in YAML to coordinate microservices, Cloud Functions, and HTTP endpoints with fast start times and low execution overhead.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated