Associate Data Practitioner Practice Questions

Google Cloud Associate Data Practitioner exam preparation

Associate Data Practitioner practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 120 minutes.

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?

  1. Define an external table in BigQuery
  2. Define a SQL model in Dataform
  3. Define a transfer rule in Cloud Storage
  4. 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.

Go to the Associate Data Practitioner practice app (10 free questions; purchase unlocks all questions)

See the full practice set