Mountkirk Games, a company that makes online, session-based, multiplayer games for mobile platforms, is building a new game which they expect to be very popular. They plan to deploy the game's backend on Google Compute Engine to capture streaming metrics, run intensive analytics, and take advantage of its autoscaling server environment. Considering the business and technical requirements such as improving uptime, reducing latency, dynamically scaling based on game activity, and managing various types of data like transactional, time series, and historical data, what should you do to define the technical architecture for the database workloads?