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

44 minutes, 55 seconds remaining!
Crucial Exams

GCP Associate Cloud Engineer Practice Question

Your production Cloud SQL for MySQL instance (instance-prod) is in us-central1 and takes automated backups every night at 02:00. Developers need a copy of last night's backup to test a schema migration in the europe-west1 region. They must receive a fully functional Cloud SQL instance as quickly as possible and without affecting the production instance's binary log position. What should you do?

  • Create a cross-region read replica of instance-prod in europe-west1 and promote it to standalone.

  • Use the Cloud SQL clone operation to clone instance-prod directly into europe-west1.

  • Export the database from instance-prod to Cloud Storage, create a new instance in europe-west1, and import the SQL dump.

  • Create a new Cloud SQL instance in europe-west1 and restore the latest automated backup from instance-prod into it.

GCP Associate Cloud Engineer
Ensuring successful operation of 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.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot