ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 40 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 40
Topic #: 1
[All Professional Cloud Database Engineer Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by chelbsik at Dec. 24, 2022, 10:54 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
pk349
Highly Voted 2 years, 1 month ago
D: Configure Memorystore and modify your application to offload queries.
upvoted 8 times
...
csrazdan
Highly Voted 2 years ago
Selected Answer: D
The question says "redesign the architecture of an application" - Caching data using MemoryStore will trigger this. Read replica will require only updating connection details which would not be considered an application redesign.
upvoted 6 times
...
887ad17
Most Recent 6 months, 1 week ago
Selected Answer: D
Memorystore for caching
upvoted 1 times
...
theseawillclaim
1 year, 4 months ago
Selected Answer: D
"sub-millisecond latency" always involves Memorystore. Furthermore, as we are talking about a relational DB (Cloud SQL), BigTable is not a solution to be considered.
upvoted 5 times
KIDDO24
1 year, 4 months ago
MEMORY STORE IS ALSO A NO RELATIONAL DB LIKE BIGTABLE
upvoted 1 times
...
RaphaelG
1 year ago
"sub-milisecond latency" always involves Bigtable if anything
upvoted 2 times
...
...
learnazureportal
1 year, 5 months ago
The correct answer is ==> B. Configure Bigtable, and modify your application to offload queries.
upvoted 1 times
learnazureportal
1 year, 5 months ago
Memorystore is an in-memory data store that can provide low-latency access to cached data, but it may not be suitable for all types of queries, and achieving sub-millisecond latency depends on factors such as data size and query complexity.
upvoted 1 times
...
...
KennyHuang
1 year, 8 months ago
Selected Answer: D
The recommended approach is to configure Memorystore (Redis) and modify your application to offload queries. This will allow you to take advantage of the sub-millisecond query latency provided by in-memory caching and significantly improve the performance of your application.
upvoted 2 times
...
felipeschossler
1 year, 9 months ago
Selected Answer: D
D. The only thing that achieves submilli seconds of response is Redis: https://blog.bytebytego.com/p/ep22-latency-numbers-you-should-know
upvoted 2 times
...
PATILDXB
1 year, 9 months ago
D. To meet demands of low latency at increased scale and reduced cost you need an in-memory datastore. Redis and Memchaced are among the most popular. Memorystore is a fully managed in-memory data store service for Redis and Memcached at Google Cloud.
upvoted 1 times
...
dynamic_dba
1 year, 10 months ago
D. A is wrong since Firestore would not offer sub-millisecond response. C would help, but sub-millisecond would still be hard to achieve. The question gives no justification for Bigtable and sub-millisecond response does strongly suggest reads from memory rather than disk. That leaves D as the best answer.
upvoted 4 times
...
muky31dec
2 years ago
Selected Answer: D
Ans is D
upvoted 1 times
...
ssaporylo
2 years, 1 month ago
C: read replica
upvoted 2 times
...
SVGoogle89
2 years, 1 month ago
sub-millisecs -> BigTable
upvoted 1 times
ssaporylo
2 years, 1 month ago
it requires additional efforts to integrate BT
upvoted 1 times
...
...
GCP72
2 years, 1 month ago
Selected Answer: C
C is the correct answer
upvoted 2 times
GCP72
2 years, 1 month ago
Sorry D is the correct answer https://cloud.google.com/blog/topics/developers-practitioners/what-memorystore/
upvoted 7 times
...
...
chelbsik
2 years, 1 month ago
Selected Answer: B
Can't find any proper docs for this case, so let's try elimination. I'm not so sure though. A and C - don't give us sub-millisecond query latency. I don't see how Memorystore can help with queries, since it's cache, so eliminate D as well.
upvoted 2 times
ssaporylo
2 years, 1 month ago
C read replica with additional indexes give benefits. PG => BT dev efforts to migrate
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel