Answer-first summary for fast verification
Answer: Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries.
The correct answer is D based on the technical requirements and community consensus. The key technical requirements include: 'Connect to a transactional database service to manage user profiles and game state' and 'Store game activity in a timeseries database service for future analysis'. Cloud Bigtable is optimal for time-series data due to its high throughput and scalability. Cloud Spanner is suitable for transactional data (user profiles and game state) as it provides global scalability, strong consistency, and supports transactions, which Bigtable does not fully support (only single-row transactions). BigQuery is ideal for historical data queries due to its ability to handle large-scale analytics (10 TB+). Option C is incorrect because Bigtable cannot adequately replace MySQL for transactional needs, lacking full transactional support. Option A and B are suboptimal as they do not align with the specific service recommendations for each data type (time-series, transactional, historical). The community discussion, with high upvotes for D (86%) and detailed reasoning, reinforces this choice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Based on the Mountkirk Games case study, you are tasked with designing the technical architecture for the company's database workloads. Considering the business and technical requirements, what is your recommended approach?
A
Use Cloud SQL for time series data, and use Cloud Bigtable for historical data queries.
B
Use Cloud SQL to replace MySQL, and use Cloud Spanner for historical data queries.
C
Use Cloud Bigtable to replace MySQL, and use BigQuery for historical data queries.
D
Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries.