Exam Professional Cloud Database Engineer All Questions

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

Exam Professional Cloud Database Engineer topic 1 question 5 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 5
Topic #: 1

[All Professional Cloud Database Engineer Questions]

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

A. Use Database Migration Service to migrate all databases to Cloud SQL.
B. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
C. Use data replication tools and CDC tools to enable migration.
D. Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Show Suggested Answer

Suggested Answer: A 🗳️

by range9005 at Dec. 19, 2022, 5:51 a.m.

Comments

Submit Cancel

Zakky_09

7 months, 2 weeks ago

Selected Answer: A

Google-recommended practices for migrating databases to Cloud SQL emphasize using the Database Migration Service (DMS) because it is a native, managed tool that supports: Minimal downtime migrations: It supports continuous data replication using change data capture (CDC). Ease of use: DMS is fully integrated with Google Cloud, making it straightforward to configure and monitor migrations. Monitoring and reliability: It provides tools for monitoring the migration progress and detecting issues. By using DMS for both one-time and ongoing replication needs, you align with Google's best practices while reducing the complexity of using multiple tools.

upvoted 1 times

...

studymoreoften

8 months, 1 week ago

Selected Answer: A

database migration service can be used to migrate from on-prem and other clouds (AWS)

upvoted 2 times

...

Killerbee05

10 months, 3 weeks ago

Selected Answer: A

A is a correct answer

upvoted 2 times

...

whoosh

1 year, 1 month ago

Selected Answer: A

https://cloud.google.com/database-migration/docs/overview

upvoted 3 times

...

jnya_1991

1 year, 1 month ago

Selected Answer: A

https://cloud.google.com/database-migration/docs/overview

upvoted 2 times

...

goodsport

1 year, 4 months ago

Selected Answer: A

A is the correct answer here.

upvoted 3 times

...

somnathmaddi

1 year, 9 months ago

Selected Answer: A

The question says to use Google native data migration tools

upvoted 3 times

nmnm22

10 months, 1 week ago

good point, thank you for pointing it out

upvoted 1 times

...

cloudkoala

1 year, 10 months ago

Selected Answer: A

DMS will do the CDC too.

upvoted 4 times

...

dynamic_dba

1 year, 10 months ago

A. The question says to use Google native data migration tools. That eliminates B and D. C doesn't specify the data replication tool in question so it's a reasonable assumption its referring to database native replication which wouldn't be a Google native solution. That eliminates C. That leave A.

upvoted 3 times

...

Nirca

1 year, 11 months ago

Selected Answer: A

DMS will do the job. For the init time and the CDC phase

upvoted 1 times

...

Hilab

1 year, 11 months ago

Option A is the most straightforward and recommended solution for migrating PostgreSQL databases to Cloud SQL while following Google-recommended practices and using native data migration tools.

upvoted 1 times

...