nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #1

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #1: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.

Migrating on-premises and self-managed databases to Google Cloud

Question

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google- recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

Options

  • ACreate a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import
  • BUse the mysqldump utility to take a backup of the existing on-premises database, and then import
  • CCreate a Compute Engine VM, install MySQL on the VM, and then import the dump file.
  • DCreate an external replica, and use Cloud SQL to synchronize the data to the replica.

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Database Migration#Cloud SQL#MySQL Replication#Minimal Downtime
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions