Migrating Game Backend and Analytics Platforms
Question
Mountkirk Games makes online, session-based, multiplayer games for mobile platforms.
They build all of their games using some server-side integration.
Historically, they have used cloud providers to lease physical servers.
Due to the unexpected popularity of some of their games, they have had problems scaling their global audience, application servers, MySQL databases, and analytics tools.
Their current model is to write game statistics to files and send them through an ETL tool that loads them into a centralized MySQL database for reporting.
Solution Concept - Mountkirk Games is building a new game, which they expect to be very popular.
They plan to deploy the game's backend on Google Compute Engine so they can capture streaming metrics, run intensive analytics, and take advantage of its autoscaling server environment and integrate with a managed NoSQL database.
Business Requirements -Increase to a global footprintImprove uptime " downtime is loss of playersIncrease efficiency of the cloud resources we useReduce latency to all customers Technical Requirements - Requirements for Game Backend PlatformDynamically scale up or down based on game activityConnect to a transactional database service to manage user profiles and game stateStore game activity in a timeseries database service for future analysisAs the system scales, ensure that data is not lost due to processing backlogsRun hardened Linux distro Requirements for Game Analytics PlatformDynamically scale up or down based on game activityProcess incoming data on the fly directly from the game serversProcess data that arrives late because of slow mobile networksAllow queries to access at least 10 TB of historical dataProcess files that are regularly uploaded by users' mobile devices Executive Statement - Which two steps should be part of their migration plan? (Choose two.)
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.AB.
The two steps that should be part of Mountkirk Games' migration plan are A and D.
A. Evaluate the impact of migrating their current batch ETL code to Cloud Dataflow. Moving from a batch ETL code to a stream processing system such as Cloud Dataflow will allow Mountkirk Games to process data on the fly and respond to game activity in real-time, as well as reduce processing backlogs. Cloud Dataflow is a managed service that supports batch and stream processing, so it can handle both the historical data and the real-time data generated by the new game. However, migrating to Cloud Dataflow may have an impact on the existing ETL code and require changes to the data ingestion process, so it is important to evaluate the impact of the migration to ensure a smooth transition.
D. Load 10 TB of analytics data from a previous game into a Cloud SQL instance, and run test queries against the full dataset to confirm that they complete successfully. Mountkirk Games needs to be able to store and query at least 10 TB of historical data, so they need a scalable database solution. Cloud SQL is a managed relational database service that can handle large datasets and scale automatically. Loading 10 TB of data into Cloud SQL and running test queries against the full dataset will confirm that the service can handle the expected workload. This step will also provide a baseline for the expected performance of the analytics platform and allow the team to optimize queries if necessary.
B, C, and E are not the correct steps to include in Mountkirk Games' migration plan:
B. Write a schema migration plan to denormalize data for better performance in BigQuery. This step is not necessary at this stage because Mountkirk Games has not yet decided to use BigQuery as their analytics platform. They are planning to use a timeseries database service to store game activity for future analysis. Furthermore, denormalization may not always improve performance, so it is important to evaluate the specific use case before making changes to the schema.
C. Draw an architecture diagram that shows how to move from a single MySQL database to a MySQL cluster. While a MySQL cluster could provide high availability and scalability, it may not be necessary for Mountkirk Games' current needs. They have not mentioned any issues with their current MySQL setup, and their focus is on improving uptime, reducing latency, and ensuring data is not lost due to processing backlogs. Therefore, the priority should be on ensuring that the new system can handle the expected workload and provide the necessary performance.
E. Integrate Cloud Armor to defend against possible SQL injection attacks in analytics files uploaded to Cloud Storage. This step is not directly related to the migration plan for the game backend and analytics platform. While security is important, it is not one of the stated business or technical requirements. It may be a good idea to evaluate the security of the system and implement additional measures as necessary, but this should not be a priority during the migration.
