exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam

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 Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
n2183712847
1 month, 3 weeks ago
Selected Answer: A
dataflow job builder is visual & dataflow is real-time
upvoted 1 times
...
n2183712847
2 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago