Answer-first summary for fast verification
Answer: Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
The scenario describes a situation where the application works as expected in the primary region (R1) and partially in the failover region (R2), with some database errors occurring in R2. Given that the application performs completely as expected when the database fails back to region R1, and that the application-related database queries work as expected when executed in isolation in R2, the issue is likely related to the synchronization or configuration between R1 and R2. Option D is the most plausible cause because it suggests that R2 is a near-real-time copy of R1 but not an exact copy, which could lead to discrepancies in data or schema that affect certain application scenarios. Options A and B are less likely because version or patch differences would likely cause more widespread issues, not just specific scenarios. Option C is not relevant because the question states that the failover has completed successfully and the database is available in R2.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What steps should you take to determine the root cause of database errors in region R2 after a successful cross-regional failover from R1, given that isolated queries work in R2 but some application scenarios fail, while the application functions normally when the database fails back to R1?
A
Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
B
Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
C
Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
D
Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.