Google Professional Data Engineer Question 189
Single answerGoogle Cloud PlatformYou are designing a data pipeline for an e-commerce platform that tracks user activity. The platform generates millions of events per hour, including page views, searches, and purchases. The business team wants to analyze trends for daily purchases, while the marketing team wants to track user behavior on an hourly basis. How should you determine the appropriate granularity of time data to meet these requirements?
- A
Store all events with millisecond granularity to ensure the highest level of detail for all teams.
- B
Store event data with daily granularity for purchase trends and hourly granularity for user behavior.
- C
Store event data with hourly granularity for all use cases to balance detail and storage efficiency.
- D
Aggregate all data to daily granularity to reduce storage costs and simplify analysis.
Show answer and explanation
Correct answer: B
Explanation
The granularity of time data should align with the specific requirements of the use case to balance storage efficiency and analytical value. In this scenario, daily granularity is sufficient for the business team to analyze purchase trends, while hourly granularity is better suited for the marketing team's need to track user behavior. Using the appropriate granularity for each use case ensures optimal performance and cost-efficiency.
- A. Incorrect.
Storing all events with millisecond granularity is unnecessary for the given use cases and would result in excessive storage and processing costs without providing additional value.
- B. Correct.
Storing event data with daily granularity for purchases and hourly granularity for user behavior matches the specific requirements of the business and marketing teams, ensuring that the data is both useful and efficient.
- C. Incorrect.
Storing all data with hourly granularity might simplify the solution but does not meet the business team's need for daily granularity for purchase trends.
- D. Incorrect.
Aggregating all data to daily granularity would fail to meet the marketing team's need for hourly user behavior tracking.