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

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

A company has a Microsoft SQL Server database in its data center and plans to migrate data to Amazon Aurora MySQL. The company has already used the AWS
Schema Conversion Tool to migrate triggers, stored procedures and other schema objects to Aurora MySQL. The database contains 1 TB of data and grows less than 1 MB per day. The company's data center is connected to AWS through a dedicated 1Gbps AWS Direct Connect connection.
The company would like to migrate data to Aurora MySQL and perform reconfigurations with minimal downtime to the applications.
Which solution meets the company's requirements?

  • A. Shut down applications over the weekend. Create an AWS DMS replication instance and task to migrate existing data from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
  • B. Create an AWS DMS replication instance and task to migrate existing data and ongoing replication from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
  • C. Create a database snapshot of SQL Server on Amazon S3. Restore the database snapshot from Amazon S3 to Aurora MySQL. Create an AWS DMS replication instance and task for ongoing replication from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
  • D. Create a SQL Server native backup file on Amazon S3. Create an AWS DMS replication instance and task to restore the SQL Server backup file to Aurora MySQL. Create another AWS DMS task for ongoing replication from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by liono at Nov. 5, 2020, 11:21 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
XRiddlerX
Highly Voted 3 years, 8 months ago
Answer is B A is incorrect because shutting down the application over the weekend will cause downtime to the application. C is incorrect because you can't restore a SQL Server snapshot to Aurora MySQL. They are two very different DBS engines D is incorrect cause you can restore a native MSSQL backup to a Aurora MySQL because they are two different DBS engines and I'm not aware of restoring backup file functionality in DMS. B is correct because since your have used the AWS SCT all you need to do for this migration is migrate the existing data and keep replication going until cutover.
upvoted 36 times
jackdryan
3 years, 7 months ago
https://docs.aws.amazon.com/dms/latest/sbs/CHAP_SQLServer2Aurora.Steps.html
upvoted 3 times
...
GopiSivanathan
3 years, 7 months ago
To transfer 1TB data over 1 Gbps ; it will take only 2 and 26 mins, is that not acceptable as this statement in the question? The company would like to migrate data to Aurora MySQL and perform reconfigurations with minimal downtime to the applications.
upvoted 1 times
StelSen
3 years, 6 months ago
Read this in Option-B -> "migrate existing data and ONGOING Replication....". So, initially it will take 2.5 hrs and afterwards it will be almost realtime sync. So, literally no downtime or may be 5 mins to just to finish last replication.
upvoted 2 times
...
...
...
SkyZeroZx
Most Recent 1 year, 11 months ago
Selected Answer: B
B. Create an AWS DMS replication instance and task to migrate existing data and ongoing replication from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
upvoted 1 times
...
cldy
3 years, 5 months ago
B. Create an AWS DMS replication instance and task to migrate existing data and ongoing replication from SQL Server to Aurora MySQL. Perform application testing and migrate the data to the new database endpoint.
upvoted 1 times
...
AzureDP900
3 years, 6 months ago
B is right
upvoted 1 times
...
andylogan
3 years, 6 months ago
It's B
upvoted 1 times
...
Suresh108
3 years, 7 months ago
BBBBBBBBBBBB https://docs.aws.amazon.com/dms/latest/sbs/chap-sqlserver2aurora.steps.html
upvoted 2 times
...
tgv
3 years, 7 months ago
BBB ---
upvoted 1 times
...
WhyIronMan
3 years, 7 months ago
I'll go with B
upvoted 1 times
...
Waiweng
3 years, 7 months ago
it's B
upvoted 2 times
...
alisyech
3 years, 7 months ago
should be B
upvoted 1 times
...
Kian1
3 years, 7 months ago
going with B
upvoted 2 times
...
Trap_D0_r
3 years, 7 months ago
B LOL you can do B with 1-2 hours of total outage time MAX (if things go very VERY poorly), and schedule that time during extremely low usage periods or scheduled outage (if you have an uptime requirement it won't affect your SLA). "A" requires a full weekend of downtime. Terrible, terrible solution. See XRiddlerX's answer for why the other two options are garbage.
upvoted 1 times
...
Superomam
3 years, 7 months ago
I've changed my idea to B. A is not wrong because it's doable but reading carefully this article https://docs.aws.amazon.com/dms/latest/sbs/CHAP_SQLServer2Aurora.Steps.htm, it seems that B should be the right answer.
upvoted 1 times
...
Superomam
3 years, 7 months ago
A. I'm currently working into the "migration arena" and every time a DB must be migrated, you've to stop the application to avoid writing to the DB.
upvoted 1 times
sarah_t
3 years, 7 months ago
you can use DMS for ongoing replication until you cut over
upvoted 1 times
...
pablobairat
3 years, 7 months ago
Your company is lucky for having you ;) It is B
upvoted 4 times
...
...
Ebi
3 years, 7 months ago
B for sure,
upvoted 4 times
...
Bulti
3 years, 7 months ago
B is the right answer. Not C because you cannot use DMS to import a SQL Server snapshot into the Aurora SQL DB.
upvoted 2 times
...
petebear55
3 years, 7 months ago
Ive seen these questions before and the answer is always A ... don't think the question is written very well. if it mentions the app needs to run 24/7 then of course i would not choose A. but given experience with similar ? i will choose A
upvoted 1 times
...
Load full discussion...
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