A data team uses Dataform to manage SQL transformations in BigQuery. They want these transformations to run automatically whenever new raw data is loaded into a BigQuery table. What should they configure?

Set up a Cloud Composer DAG that triggers Dataform after a BigQuery job completes.

Create an Eventarc trigger that listens for BigQuery table insert events and invokes a Dataform workflow.

Use Cloud Functions to call the Dataform API after every BigQuery load job.

Schedule a Dataform workflow with Cloud Scheduler to run every hour.

Google CloudAssociate Data Practitioner

Domain 3Objective 2

3.2 Schedule, Automate, and Monitor Basic Data Processing Tasks ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 4)

Part of the Data Pipeline Orchestration domain, which accounts for ~18% of the ASSOCIATE-DATA-PRACTITIONER exam.

37questions here

8free pages

14concepts

~18%of the exam

Questions 16–20

16foundation · easy
A data practitioner needs to orchestrate a pipeline that includes multiple steps: calling a Cloud Run service, waiting for its completion, then running a BigQuery job. Which service is designed for orchestrating multiple Google Cloud services in a serverless manner?
Select an answer first
17application · medium
A data team uses Dataform to manage SQL transformations in BigQuery. They want these transformations to run automatically whenever new raw data is loaded into a BigQuery table. What should they configure?
Select an answer first
18foundation · easy
A data practitioner wants to create a visual dashboard that shows the CPU utilization of their data processing VMs and set up an alert if it exceeds 80%. Which Google Cloud service should they use?
Select an answer first
19foundation · easy
A data practitioner wants to stream data from Pub/Sub into BigQuery for real-time analytics. Which Google Cloud service is commonly used to read from Pub/Sub and write to BigQuery?
Select an answer first
20foundation · easy
A data practitioner needs to orchestrate a simple pipeline that runs a single SQL query on a schedule and writes results to a BigQuery table. Which solution is the most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-DATA-PRACTITIONER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “ASSOCIATE-DATA-PRACTITIONER” is a trademark of its owner, used for identification only.

3.2 Schedule, Automate, and Monitor Basic Data Processing Tasks ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 4)

Questions 16–20

A data practitioner needs to orchestrate a pipeline that includes multiple steps: calling a Cloud Run service, waiting for its completion, then running a BigQuery job. Which service is designed for orchestrating multiple Google Cloud services in a serverless manner?

A data team uses Dataform to manage SQL transformations in BigQuery. They want these transformations to run automatically whenever new raw data is loaded into a BigQuery table. What should they configure?

A data practitioner wants to create a visual dashboard that shows the CPU utilization of their data processing VMs and set up an alert if it exceeds 80%. Which Google Cloud service should they use?

A data practitioner wants to stream data from Pub/Sub into BigQuery for real-time analytics. Which Google Cloud service is commonly used to read from Pub/Sub and write to BigQuery?

A data practitioner needs to orchestrate a simple pipeline that runs a single SQL query on a schedule and writes results to a BigQuery table. Which solution is the most appropriate?

Keep studying — Data Pipeline Orchestration