ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 104 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 104
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

  • A. 1. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
    2. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
  • B. 1. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
    2. Schedule downtime to run each Cloud Data Fusion pipeline.
    3. Verify that the migration was successful.
    4. Re-point the applications to the Cloud SQL for MySQL instance.
  • C. 1. Pause the on-premises applications.
    2. Use the mysqldump utility to dump the database content in compressed format.
    3. Run gsutil –m to move the dump file to Cloud Storage.
    4. Use the Cloud SQL for MySQL import option.
    5. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
  • D. 1 Pause the on-premises applications.
    2. Use the mysqldump utility to dump the database content in CSV format.
    3. Run gsutil –m to move the dump file to Cloud Storage.
    4. Use the Cloud SQL for MySQL import option.
    5. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by chelbsik at Dec. 26, 2022, 10:45 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
DPonly
8 months ago
Selected Answer: A
Database Migration Service supports one-time and continuous migrations from source databases to Cloud SQL destination databases.
upvoted 1 times
...
dynamic_dba
1 year, 1 month ago
A. Preserve transactions and minimize downtime. That eliminates B, C and D. A is the best answer.
upvoted 2 times
...
Nirca
1 year, 1 month ago
Selected Answer: A
A is the right one for me.
upvoted 2 times
...
orbo
1 year, 3 months ago
Selected Answer: A
To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.
upvoted 2 times
...
SVGoogle89
1 year, 4 months ago
A https://cloud.google.com/database-migration/docs/mysql/configure-source-database
upvoted 1 times
...
chelbsik
1 year, 4 months ago
Selected Answer: A
A looks like the best option to me
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago