GCP Associate Cloud Engineer Practice Question

You are migrating an on-premises MySQL 5.7 database used by a legacy PHP application running on Compute Engine. The team wants Google to handle backups, minor version patching, and automatic failover inside a region. In addition, the business continuity plan requires that if the entire region fails, the database can be promoted in a different region with an RPO under one hour. Which Google Cloud deployment best meets these requirements while requiring the least application change?

  • Create a multi-region Cloud Spanner instance to store the application data.

  • Migrate the data to Cloud Bigtable with multi-cluster routing enabled across two regions.

  • Create a Cloud SQL for MySQL instance with high-availability enabled and add a cross-region read replica that can be promoted during a regional outage.

  • Provision a single-zone Cloud SQL for PostgreSQL instance with automated backups.

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