For this question, refer to the Mountkirk Games case study. Which managed storage option meets Mountkirk's technical requirement for storing game activity in a time series database service?
Big Query. in the case study, interactions with users are directly with GKE. GKE push events on Pub/Sub and then Dataflow take events and go to BQ. Activity from Stackdriver Logging to Cloud Storage to Dataflow to BQ.
Answer is A BigTable. Thats the best solution to process and store the data, BiqQuery can be used to analyse the data. Big Query not a suitable target for time series.
C - BigQuery
BigTable is Wrong: BigTable is timeseries with "low latency" and they didnt mention anything about low-latency. They did mention about future analysis so BQ is best.
DataStore is wrong Choice: DataStore is good for transactional data e.g. saving and updating game state as it chnages. In the question they are talking about game activity which is a serious on insert only data based on time.
Google says we can store time series vehicle data in Bigtable which can later be used for analytical processing using BigQuery.
https://cloud.google.com/architecture/designing-connected-vehicle-platform#data_ingestion
Even though it says vehicle data and the question is for game data we eventually are storing time series type of data so I think this link is relevant.
Based on Google explanation, I would choose A
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.
Eroc
Highly Voted 4 years, 12 months agozbyszekz
3 years, 1 month agosri007
Highly Voted 4 years, 9 months agosalvo007
Most Recent 9 months agoanirban7172
1 year, 4 months agomegumin
1 year, 11 months agoAzureDP900
2 years agojabrrJ68w02ond1
2 years, 1 month agoburner_1984
2 years, 9 months agovincy2202
2 years, 10 months agojoe2211
2 years, 11 months agoRzla
3 years, 1 month agoMamthaSJ
3 years, 3 months agovictory108
3 years, 5 months agogosi
3 years, 6 months agoKoushick
3 years, 6 months agoAusias18
3 years, 6 months agolynx256
3 years, 6 months ago