In the updated case study : they are asking for "Connect to a transactional database service to manage user profiles and game state". So how will using bigtable solve this ? why is not answer B. As they have plans to be global and they need transactional database.
You are planning the best database workloads for Mountkirk Games analytics requirements. Considering the business and technical requirements, what actions should you take?
Use Cloud SQL for time series data. Use Cloud Bigtable for historical data queries.
Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries.
Replace MySQL with Cloud SQL and use Cloud Spanner for historical data queries.
Use Cloud Bigtable to replace MySQL and use BigQuery for historical data queries.
Your Answer: B
Why is this incorrect?
One of the requirements is to use a NoSQL database for transactional data. Cloud Spanner is a SQL/relational database.
Correct Answer: D
Why is this correct?
This is the most correct answer of the given choices. Bigtable is well suited for holding time series data and BigQuery can query data in Bigtable. Alternatively, BigQuery can also be used for both solutions if low latency response times are not required.