SAP-C02 · Question #21
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…
The correct answer is C. Create an Amazon Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) to do a. "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.
Question
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?
Options
- ACreate an Amazon Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) to do a
- BDuring nonbusiness hours, shut down the on-premises database and create a backup. Restore
- CCreate an Amazon Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) to do a
- DCreate a backup of the database and restore it to an Amazon Aurora multi-master cluster. This
How the community answered
(41 responses)- A15% (6)
- B2% (1)
- C73% (30)
- D10% (4)
Explanation
"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.
Community Discussion
No community discussion yet for this question.