Exam Associate-Data-Practitioner Topic 1 Question 106 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 106
Topic #: 1
You work for a healthcare company. You have a daily ETL pipeline that extracts patient data from a legacy system, transforms it, and loads it into BigQuery for analysis. The pipeline currently runs manually using a shell script. You want to automate this process and add monitoring to ensure pipeline observability and troubleshooting insights. You want one centralized solution, using open-source tooling, without rewriting the ETL code. What should you do?

Suggested Answer: A Vote an answer

Comprehensive and Detailed in Depth Explanation:
Why A is correct:Cloud Composer is a managed Apache Airflow service, which is a popular open-source workflow orchestration tool.
DAGs in Airflow can be used to automate ETL pipelines.
Airflow's web interface and Cloud Monitoring provide comprehensive monitoring capabilities.
It also allows you to run existing shell scripts.
Why other options are incorrect:B: Dataflow requires rewriting the ETL pipeline using its SDK.
C: Dataproc is for big data processing, not orchestration.
D: Cloud Run functions are for stateless applications, not long-running ETL pipelines.

by George at Feb 26, 2026, 10:17 AM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10