A company runs a nightly batch of three interdependent Spark jobs on Dataproc. They want to orchestrate these jobs with minimal overhead and without managing additional infrastructure. What is the most appropriate solution?

Use Workflows to call the Dataproc API for each job.

Write a shell script that submits each Spark job sequentially and run it on a VM.

Use Cloud Composer to run the Spark jobs via Dataproc operators.

Create a Dataproc Workflow Template that defines the sequence of Spark jobs.

A company wants to run a BigQuery scheduled query every weekday at 6:00 AM. However, they also need to ensure that the query does not run on public holidays. What is the most efficient way to handle this?

Use a Dataform workflow scheduled with Cloud Scheduler and a holiday check.

Create a Cloud Scheduler job that triggers a Cloud Function, which checks a holiday calendar before running the query.

Create a Cloud Composer DAG with a holiday sensor.

Use BigQuery scheduled queries with a custom schedule that excludes holidays.

How can a Cloud Function be triggered by an event from Cloud Storage?

Using a Dataproc Workflow Template

Using a BigQuery scheduled query

Google CloudAssociate Data Practitioner

Domain 3Objective 2

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

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 31–35

31foundation · easy
A data practitioner wants to trigger a Cloud Run service whenever a new file is uploaded to a Cloud Storage bucket. Which service should they use to route the storage event to the Cloud Run service?
Select an answer first
32application · medium
A company runs a nightly batch of three interdependent Spark jobs on Dataproc. They want to orchestrate these jobs with minimal overhead and without managing additional infrastructure. What is the most appropriate solution?
Select an answer first
33foundation · easy
A data practitioner needs to run a SQL query that aggregates daily sales data in BigQuery every morning at 6:00 AM. Which BigQuery feature should they use to accomplish this without manually running the query each day?
Select an answer first
34application · hard
A company wants to run a BigQuery scheduled query every weekday at 6:00 AM. However, they also need to ensure that the query does not run on public holidays. What is the most efficient way to handle this?
Select an answer first
35foundation · easy
How can a Cloud Function be triggered by an event from Cloud Storage?
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 7)

Questions 31–35

A data practitioner wants to trigger a Cloud Run service whenever a new file is uploaded to a Cloud Storage bucket. Which service should they use to route the storage event to the Cloud Run service?

A company runs a nightly batch of three interdependent Spark jobs on Dataproc. They want to orchestrate these jobs with minimal overhead and without managing additional infrastructure. What is the most appropriate solution?

A data practitioner needs to run a SQL query that aggregates daily sales data in BigQuery every morning at 6:00 AM. Which BigQuery feature should they use to accomplish this without manually running the query each day?

A company wants to run a BigQuery scheduled query every weekday at 6:00 AM. However, they also need to ensure that the query does not run on public holidays. What is the most efficient way to handle this?

How can a Cloud Function be triggered by an event from Cloud Storage?

Keep studying — Data Pipeline Orchestration