Google Cloud Professional Cloud Developer — Question 344

Your team developed a web-based game that has many simultaneous players. Recently, users have started to complain that the leaderboard tallies the top scores too slowly. You investigated the issue and discovered that the application stack is currently using Cloud SQL for PostgreSQL. You want to improve the leaderboard performance as much as possible to provide a better user experience. What should you do?

Answer options

• A. Re-implement the leaderboard data to be stored in Memorystore for Redis.
• B. Optimize the SQL queries to minimize slow-running queries.
• C. Migrate the database and store the data in AlloyDB.
• D. Update Cloud SQL for PostgreSQL to the latest version.

Correct answer: A

Explanation

Storing leaderboard data in Memorystore for Redis (Option A) allows for faster access times due to its in-memory capabilities, significantly improving performance. While optimizing SQL queries (Option B) and updating Cloud SQL (Option D) could help, they may not achieve the same level of performance enhancement as using a dedicated in-memory store like Redis. Migrating to AlloyDB (Option C) may also improve performance, but it involves more complexity and resources compared to simply switching to Redis.