PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #4
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
Options
- ACreate and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to
- BCreate two Datastream connection profiles, and use them to create a stream from one Cloud SQL
- CCreate a SQL dump file in Cloud Storage using a temporary instance, and then use that file to
- DCreate a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a
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.