ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 50 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 50
Topic #: 1
[All Associate Data Practitioner Questions]

Your organization’s ecommerce website collects user activity logs using a Pub/Sub topic. Your organization’s leadership team wants a dashboard that contains aggregated user engagement metrics. You need to create a solution that transforms the user activity logs into aggregated metrics, while ensuring that the raw data can be easily queried. What should you do?

  • A. Create a Dataflow subscription to the Pub/Sub topic, and transform the activity logs. Load the transformed data into a BigQuery table for reporting.
  • B. Create an event-driven Cloud Run function to trigger a data transformation pipeline to run. Load the transformed activity logs into a BigQuery table for reporting.
  • C. Create a Cloud Storage subscription to the Pub/Sub topic. Load the activity logs into a bucket using the Avro file format. Use Dataflow to transform the data, and load it into a BigQuery table for reporting.
  • D. Create a BigQuery subscription to the Pub/Sub topic, and load the activity logs into the table. Create a materialized view in BigQuery using SQL to transform the data for reporting
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by n2183712847 at Feb. 27, 2025, 3:26 p.m.

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
Submit Cancel
n2183712847
1 month, 3 weeks ago
Selected Answer: D
D. Keeps original data easily queried, while also transforming into BQ.
upvoted 1 times
...
n2183712847
2 months ago
Selected Answer: D
Option D is the clear winner. BigQuery subscriptions + materialized views are purpose-built for this. Dataflow (A) works, but is more overhead. Cloud Run (B) isn't suitable for continuous processing, and Cloud Storage (C) adds unnecessary steps. Option D is the most efficient and keeps the raw data accessible.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago