Associate Data Practitioner free question 7 / 10 · Domain 3: Data Pipeline Orchestration
You want to run a small number of HTTP API calls in order, with conditional branches and retries, in a serverless way. Airflow compatibility is not a requirement. Which option is a candidate?
- Define an external table in BigQuery
- Define a SQL model in Dataform
- Define a transfer rule in Cloud Storage
- Define the call steps in Workflows
Show the answer and explanation
Answer: D
Why this is correct
The Workflows overview says: "Workflows is a fully managed orchestration platform that executes services in an order that you define: a workflow." It runs API calls and service integrations in sequence, and fits a use where you define branches and retries based on state.
Why the other options are wrong
"Define an external table in BigQuery" … It defines a table that refers to external data. It does not run a stateful procedure across HTTP services.
"Define a transfer rule in Cloud Storage" … It can store and manage objects, but it does not express a process of conditional branches and retries for HTTP APIs.
"Define a SQL model in Dataform" … It is specialized in SQL transformations in BigQuery, and it is not the option for mainly handling general call flows of HTTP APIs.
Key point
Even with few steps, orchestration helps when a service integration involves errors or waiting. Think of Workflows as separate from an engine that transforms large volumes of data.