Google Professional Cloud Developer Question 460
Single answerGoogle Cloud PlatformYou are developing a web application on Google Cloud that retrieves data from a Cloud SQL database. The database experiences high query loads due to repeated requests for the same data. You want to improve performance and reduce database load by caching the results of these queries. Which approach should you use to implement caching effectively?
- A
Use Memorystore to cache query results in-memory and retrieve them when the same query is requested.
- B
Enable read replicas for the Cloud SQL database to manage the load without implementing caching.
- C
Implement a Cloud Storage bucket to store query results and fetch them when requested.
- D
Add a Cloud Pub/Sub topic to publish query results and subscribe to them when needed.
Show answer and explanation
Correct answer: A
Explanation
Caching query results in-memory using Memorystore is the best approach in this scenario. Memorystore provides low-latency access to cached data and reduces the load on the Cloud SQL database by preventing repeated queries for the same data. Other options, like read replicas or Cloud Storage, are either not designed for caching or do not offer the performance benefits required for this use case.
- A. Correct.
Using Memorystore (Redis or Memcached) is an effective way to cache query results in-memory, which significantly improves response times for repeated queries and reduces database load.
- B. Incorrect.
Read replicas improve database scalability for read-heavy workloads but do not implement caching, which is the primary requirement in this scenario.
- C. Incorrect.
Cloud Storage is designed for object storage and is not suitable for low-latency, high-frequency query caching.
- D. Incorrect.
Cloud Pub/Sub is a messaging service used for event-driven architectures, not for caching query results.