🔥 40% Off Crucial Exams Memberships — Deal ends today!

1 hour, 26 minutes remaining!

GCP Associate Cloud Engineer Practice Question

Your company runs a business-critical MySQL database on a single-region Cloud SQL instance in us-central1. Users in Europe complain that read-only queries against reporting dashboards are slow, but all write traffic must continue to be handled in the United States. Management also wants a disaster-recovery option in case the us-central1 region becomes unavailable. Which solution meets the requirements with the least operational effort?

  • Create a cross-region Cloud SQL read replica of the existing instance in europe-west1, direct European read traffic to the replica, and document a runbook to manually promote the replica if the primary region fails.

  • Add a Cloud SQL failover replica in europe-west1 and route European read traffic to it while keeping writes on the primary.

  • Migrate the workload to Cloud Spanner in a multi-region configuration to achieve global reads and disaster recovery.

  • Enable Cloud SQL's automatic read/write splitting feature so reads are transparently routed to the nearest region.

GCP Associate Cloud Engineer
Planning and implementing a cloud solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot