Google Exam Professional Cloud Database Engineer Topic 1 Question 44 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 44
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat

a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

ADetermine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

BDetermine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

CDetermine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

DDetermine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Show Suggested Answer

Suggested Answer: D

Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria

by Rosalyn at Sep 16, 2024, 01:16 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tijuana

2 months ago

Hey, maybe the database is just feeling a little homesick for region R1! It's like a teenager trying to adjust to a new school.

upvoted 0 times

...

Virgie

2 months ago

I think we should also consider checking whether the database patches of Cloud SQL for PostgreSQL in regions R1 and R2 are different. That could also be a potential cause of the errors.

upvoted 0 times

...

2 months ago

Hmm, I think the answer is B. The database patches might be different between the two regions, causing the issues.

upvoted 0 times

Jerlene

1 months ago

D) Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

upvoted 0 times

...

Monte

1 months ago

C) Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

upvoted 0 times

...

Sylvia

2 months ago

B) Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

upvoted 0 times

...

Nathan

2 months ago

A) Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

upvoted 0 times

...

Lachelle

3 months ago

I think we should determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

upvoted 0 times

...