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 121 discussion

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

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

  • A. Restore the Cloud SQL instance from the automatic backups in region 3.
  • B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
  • C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
  • D. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by dynamic_dba at March 28, 2023, 1:06 a.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
dynamic_dba
Highly Voted 1 year, 7 months ago
C. No need for restores if you have a read replica which you can promote to be the new primary. Eliminate A and B. Failovers do not happen automatically to read replicas. You have to promote them. Eliminate D. That leaves C which is supported by Google's documentation. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
upvoted 9 times
...
nmnm22
Most Recent 7 months, 1 week ago
Selected Answer: C
answer C makes sense, special thanks to dynamic dba
upvoted 1 times
...
ArtistS
10 months, 3 weeks ago
Agree with dynamic_dba too, thanks for the perfect document
upvoted 2 times
...
DPonly
1 year, 2 months ago
Selected Answer: C
C is the only option ,
upvoted 1 times
...
absero1609
1 year, 6 months ago
Selected Answer: C
agree with dynamic_dba. Read his reference link
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago