Google Cloud Professional Cloud Database Engineer — Question 65

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

Answer options

• A. Configure Firestore, and modify your application to offload queries.
• B. Configure Bigtable, and modify your application to offload queries.
• C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
• D. Configure Memorystore, and modify your application to offload queries.

Correct answer: D

Explanation

The correct answer is D because Memorystore provides in-memory data storage which significantly reduces query response times, achieving sub-millisecond latency. The other options involve systems that may not be optimized for such low-latency requirements, such as Firestore and Bigtable, or involve read replicas that do not inherently enhance latency like Memorystore does.