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 28 discussion

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

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

  • A. Use Database Migration Service to migrate the databases to Cloud SQL.
  • B. Use a cross-region read replica to migrate the databases to Cloud SQL.
  • C. Use replication from an external server to migrate the databases to Cloud SQL.
  • D. Use an external read replica to migrate the databases to Cloud SQL.
  • E. Use a read replica to migrate the databases to Cloud SQL.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by fredcaram at Dec. 20, 2022, 10:04 p.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
Devops2022
6 days, 12 hours ago
Selected Answer: AD
Can anyone explain why D is not the right answer?
upvoted 1 times
...
dunhill
8 months, 1 week ago
Selected Answer: AC
replication from an external server is for db migration.
upvoted 1 times
...
juliorevk
1 year, 6 months ago
Selected Answer: AC
A because Database migration service is the managed offering C because the external server is used for migration. The others aren't approaches aren't actual methods for migration.
upvoted 1 times
...
Pilot50
1 year, 12 months ago
Selected Answer: AC
no other choices are correct
upvoted 1 times
...
dynamic_dba
2 years ago
A, C. B doesn’t make sense since the DBs aren’t in Cloud SQL yet. D and E don’t makes sense because no method is attached to either answer and you wouldn’t use a read replica as a source anyway. That leaves A and C. A makes sense since it can be scheduled and is online hence little/no downtime. Native DB replication of an external (on prem) server is basically what the Database Migration Service is doing. Which makes C correct as well.
upvoted 1 times
Ral17
4 months ago
Why can't you use a read replica as a source for migration if it is being synced with the primary instance?
upvoted 1 times
...
...
Nirca
2 years ago
Selected Answer: AC
A & C is the correct Answer
upvoted 1 times
...
pk349
2 years, 3 months ago
A: Use Database Migration Service ***** to migrate the databases to Cloud SQL. C: Use replication ***** from an external server to migrate the databases to Cloud SQL.
upvoted 2 times
...
GCP72
2 years, 3 months ago
A & C is the correct Answer
upvoted 2 times
...
lapeyus
2 years, 3 months ago
Selected Answer: AC
https://cloud.google.com/sql/docs/mysql/replication/manage-replicas#basic-steps-to-change-parallel-replication-flags
upvoted 1 times
...
range9005
2 years, 3 months ago
Selected Answer: AC
A is Database Migration Service to migrate the databases with CDC C is Replication from an external server is used to Migration Database to Cloud SQL
upvoted 1 times
...
fredcaram
2 years, 3 months ago
Selected Answer: AC
Using A for CDC makes sense to me and C is an option as well
upvoted 1 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