Topic 1 Question 50
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?
Create a Dataflow subscription to the Pub/Sub topic, and transform the activity logs. Load the transformed data into a BigQuery table for reporting.
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.
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.
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
ユーザの投票
コメント(2)
- 正解だと思う選択肢: 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.
👍 1n21837128472025/02/27 - 正解だと思う選択肢: D
D. Keeps original data easily queried, while also transforming into BQ.
👍 1n21837128472025/03/08
シャッフルモード