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

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam
Go to Exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 747 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional
Question #: 747
Topic #: 1
[All AWS Certified Solutions Architect - Professional Questions]

A company hosts a large on-premises MySQL database at its main office that supports an issue tracking system used by employees around the world. The company already uses AWS for some workloads and has created an Amazon Route 53 entry for the database endpoint that points to the on-premises database.
Management is concerned about the database being a single point of failure and wants a solutions architect to migrate the database to AWS without any data loss or downtime.
Which set of actions should the solutions architect implement?

  • A. Create an Amazon Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) to do a full load from the on-premises database to Aurora. Update the Route 53 entry for the database to point to the Aurora cluster endpoint, and shut down the on-premises database.
  • B. During nonbusiness hours, shut down the on-premises database and create a backup. Restore this backup to an Amazon Aurora DB cluster. When the restoration is complete, update the Route 53 entry for the database to point to the Aurora cluster endpoint, and shut down the on-premises database.
  • C. Create an Amazon Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) to do a full load with continuous replication from the on-premises database to Aurora. When the migration is complete, update the Route 53 entry for the database to point to the Aurora cluster endpoint, and shut down the on- premises database.
  • D. Create a backup of the database and restore it to an Amazon Aurora multi-master cluster. This Aurora cluster will be in a master-master replication configuration with the on-premises database. Update the Route 53 entry for the database to point to the Aurora cluster endpoint, and shut down the on- premises database.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Jaypdv at May 1, 2021, 4:24 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

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
Jaypdv
Highly Voted 3 years, 2 months ago
C. Got the feeling some of those questions come from the DB Specialist cert.
upvoted 14 times
...
hilft
Most Recent 2 years, 4 months ago
A or C? Seems it's C
upvoted 1 times
...
tartarus23
2 years, 7 months ago
Selected Answer: C
C. does not have a downtime or data loss since live replication happens so on-premise DB is still operational until the new AWS Aurora DB is completely migrated.
upvoted 2 times
...
tartarus23
2 years, 8 months ago
Selected Answer: C
continuous replication from on-premises to Aurora is a feasible solution.
upvoted 1 times
...
Ni_yot
2 years, 9 months ago
Yah its C. Continuous replication is the key here. No downtime or data loss. Just do a cutover to finalize the migration when complete.
upvoted 1 times
...
AzureDP900
3 years ago
I will go with C, there is no dataloss with this option
upvoted 1 times
...
andylogan
3 years, 1 month ago
It's C
upvoted 1 times
...
tgv
3 years, 1 month ago
CCC ---
upvoted 1 times
...
WhyIronMan
3 years, 1 month ago
I'll go with C
upvoted 4 times
...
vimgoru24
3 years, 1 month ago
C “Around the world” eliminates possibility for the maintenance window at night. The other difference is ability to leverage continuous replication in MySQL to Aurora case.
upvoted 3 times
...
hk436
3 years, 1 month ago
C is my answer!!
upvoted 1 times
...
vkbajoria
3 years, 1 month ago
Always choose full load with continuous replication. C
upvoted 2 times
...
Waiweng
3 years, 2 months ago
it's C
upvoted 2 times
...
LCC92
3 years, 2 months ago
go with C
upvoted 1 times
...
beebatov
3 years, 2 months ago
Answer: C AWS DMS + CDC to capture daily changes
upvoted 2 times
...
gsw
3 years, 2 months ago
i agree with C
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