As part of implementing their disaster recovery plan, your company is trying to replicate their production MySQL database from their private data center to their GCP project using a Google Cloud VPN connection. They are experiencing latency issues and a small amount of packet loss that is disrupting the replication. What should they do?
Choose an answer
Tap an option to check your answer.
Correct answer: Configure a Google Cloud Dedicated Interconnect..
Why this is the answer
Dedicated Interconnect provides a direct, private connection between your on-premises data center and Google Cloud, offering higher bandwidth, lower latency, and improved reliability compared to VPN. This dedicated link is ideal for scenarios like database replication where consistent performance and minimal packet loss are critical. Using UDP for replication is unsuitable as it's a connectionless protocol that doesn't guarantee delivery or order, which is essential for database integrity. Restoring the database daily via Cloud SQL is a recovery strategy, not a replication solution, and doesn't address the underlying connectivity issue. Adding more VPN connections might increase aggregate bandwidth but won't inherently solve latency or packet loss issues on individual connections, and managing multiple VPN tunnels can add complexity. Sending transactions to Pub/Sub is an architectural change for event-driven systems, not a direct solution for improving existing database replication over a problematic network link.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed