Exam Associate Data Practitioner topic 1 question 45 discussion

Actual exam question from Google's Associate Data Practitioner

Question #: 45
Topic #: 1

[All Associate Data Practitioner Questions]

You need to create a data pipeline that streams event information from applications in multiple Google Cloud regions into BigQuery for near real-time analysis. The data requires transformation before loading. You want to create the pipeline using a visual interface. What should you do?

A. Push event information to a Pub/Sub topic. Create a Dataflow job using the Dataflow job builder.
B. Push event information to a Pub/Sub topic. Create a Cloud Run function to subscribe to the Pub/Sub topic, apply transformations, and insert the data into BigQuery.
C. Push event information to a Pub/Sub topic. Create a BigQuery subscription in Pub/Sub.
D. Push event information to Cloud Storage, and create an external table in BigQuery. Create a BigQuery scheduled job that executes once each day to apply transformations.

Show Suggested Answer

Suggested Answer: A 🗳️

by n2183712847 at Feb. 27, 2025, 4:25 p.m.

Comments

Submit Cancel

n2183712847

3 months, 1 week ago

Selected Answer: A

dataflow job builder is visual & dataflow is real-time

upvoted 1 times

...

n2183712847

3 months, 3 weeks ago

Selected Answer: A

The best solution is A. Push event information to a Pub/Sub topic. Create a Dataflow job using the Dataflow job builder. This is because it directly addresses all requirements: streaming data from multiple regions using Pub/Sub, transformations within Dataflow, near real-time analysis with Dataflow streaming pipelines, and a visual interface using the Dataflow Job Builder. Option B (Cloud Run) is less ideal for robust streaming pipelines and visual creation. Option C (BigQuery Subscription) lacks data transformation. Option D (Cloud Storage/Scheduled Job) is a batch, daily process, not near real-time streaming.

upvoted 1 times

...