exam questions

Exam Professional Cloud Database Engineer All Questions

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

Exam Professional Cloud Database Engineer topic 1 question 113 discussion

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

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

  • A. Use Cloud SQL with cross-region replicas.
  • B. Use high availability (HA) Cloud SQL with multiple zones.
  • C. Use zonal Cloud SQL without high availability (HA).
  • D. Use Cloud Spanner in a regional configuration.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
marpayer
Highly Voted 1 year, 9 months ago
D - spanner ABC it is about Cloud SQL and the options don't offer anything to improve writing latency
upvoted 10 times
...
chelbsik
Highly Voted 1 year, 10 months ago
Selected Answer: C
Another metric to note is that the latency for regional persistent disk with solid-state drives (SSD) is higher than it would be for a zonal persistent disk with SSD. https://cloud.google.com/sql/docs/mysql/high-availability#ha-performance
upvoted 9 times
ArtistS
10 months, 2 weeks ago
I think is D. A only increase the HA
upvoted 1 times
...
...
jjyy80
Most Recent 7 months, 2 weeks ago
Selected Answer: C
multiples zonas has more latency
upvoted 1 times
...
PKookNN
9 months, 1 week ago
Selected Answer: D
The only one with write latency is regional Spanner
upvoted 1 times
...
learnazureportal
1 year, 1 month ago
Correct answer is D - Use Cloud Spanner in a regional configuration.
upvoted 1 times
...
DPonly
1 year, 1 month ago
Selected Answer: D
its Cloud SQL vs Spanner . Spanner has advantage in writing latency
upvoted 2 times
...
srishti2102
1 year, 2 months ago
A, B, C. replicas and HA will help in improving read latency only. Cloud SQL enables customers to implement horizontal scaling of read-only workloads using read replicas. It might degrade the write latency. D. Spanner satisfies the requirement without sacrificing availability
upvoted 1 times
...
TQM__9MD
1 year, 2 months ago
Selected Answer: D
I think D.
upvoted 1 times
...
badrisrinivas9
1 year, 3 months ago
Selected Answer: D
Spanner has higher write latency than other options
upvoted 3 times
...
[Removed]
1 year, 3 months ago
Selected Answer: D
D: just choose Cloud Spanner over Cloud SQL
upvoted 2 times
...
DBAgain
1 year, 3 months ago
Selected Answer: D
A and B add latency. C screams of an anti-pattern to me (no HA). Spanner satisfies the requirement without sacrificing availability, so D.
upvoted 2 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago