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

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

A company runs an application that gives users the ability to search for videos and related information by using keywords that are curated from content providers.
The application data is stored in an on-premises Oracle database that is 800 GB in size.
The company wants to migrate the data to an Amazon Aurora MySQL DB instance. A solutions architect plans to use the AWS Schema Conversion Tool and
AWS Database Migration Service (AWS DMS) for the migration. During the migration, the existing database must serve ongoing requests. The migration must be completed with minimum downtime.
Which solution will meet these requirements?

  • A. Create primary key indexes, secondary indexes, and referential integrity constraints in the target database before starting the migration process.
  • B. Use AWS DMS to run the conversion report for Oracle to Aurora MySQL. Remediate any issues. Then use AWS DMS to migrate the data.
  • C. Use the M5 or C5 DMS replication instance type for ongoing replication.
  • D. Turn off automatic backups and logging of the target database until the migration and cutover processes are complete.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by pkboy78 at Aug. 19, 2021, 3:53 p.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
tgv
Highly Voted 3 years, 6 months ago
BBB --- Key words: "A solutions architect PLANS to use the AWS Schema Conversion Tool and AWS Database Migration Service (AWS DMS) for the migration" so running the conversion report for Oracle to Aurora MySQL hasn't been done yet https://docs.aws.amazon.com/dms/latest/sbs/chap-rdsoracle2aurora.html A: AWS actually recommends to: "drop primary key indexes, secondary indexes, referential integrity constraints, and data manipulation language (DML) triggers. Or you can delay their creation until after the full load tasks are complete" --> https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html C: M5 doesn't exist --> https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html D: You can't disable automated backups on Aurora. The backup retention period for Aurora is managed by the DB cluster --> https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html
upvoted 13 times
Coffeinerd
3 years, 6 months ago
B seems the most logical, we are talking about migration with no downtime, not about increase speed of loading data, so B is the best here.
upvoted 1 times
...
...
TomPaschenda
Highly Voted 3 years, 6 months ago
Following the replies here it seems that no answer can be correct (see tgv + Jupi) My guess: there is a typo in answer B - it should be AWS SCT in the first part of the answer. Then it all makes sense.
upvoted 10 times
...
evargasbrz
Most Recent 2 years, 3 months ago
Selected Answer: B
I'll go with B, but It seems like the answers don't match the question or there are some typos or mistakes. I think the first tool in B should be SCT.
upvoted 2 times
...
bobsmith2000
2 years, 11 months ago
It seems like the answers don't match the question or there are some typos or mistakes
upvoted 2 times
...
Kuang
3 years, 1 month ago
B is my answer
upvoted 1 times
...
Bigbearcn
3 years, 2 months ago
Selected Answer: D
It's D.
upvoted 1 times
...
cldy
3 years, 4 months ago
B. Use AWS SCT to run the conversion report for Oracle to Aurora MySQL. Remediate any issues. Then use AWS DMS to migrate the data.
upvoted 1 times
mnsait
4 months, 1 week ago
Yes, this seems to be the right set of things to do. You run SCT first and get the conversion report. Based on the report, take remediate action for those that are not automatically handled. Then use DMS to migrate the data.
upvoted 1 times
...
...
AzureDP900
3 years, 4 months ago
B is right
upvoted 1 times
...
acloudguru
3 years, 4 months ago
Selected Answer: B
The first tool in B should be SCT, then B will be the answer. Anyway this is the simplest migration question i've met so far ,hope I can have it in my exam
upvoted 3 times
...
andylogan
3 years, 5 months ago
It's B
upvoted 1 times
...
Kopa
3 years, 6 months ago
I will go for B
upvoted 1 times
...
tgv
3 years, 6 months ago
GUYS, You can't disable automated backups on Aurora https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html It cannot be D
upvoted 2 times
network_zeal
3 years, 6 months ago
good catch. B seems to be right answer. yes, schema Conversion is done by SCT but SCT is a part of DMS.
upvoted 2 times
...
student22
3 years, 6 months ago
Yes, the link clearly states that: "You can't disable automated backups on Aurora. The backup retention period for Aurora is managed by the DB cluster." As TomPaschenda has mentioned, it looks like there's a typo in Answer B which should be SCT in the first part.
upvoted 1 times
...
...
blackgamer
3 years, 6 months ago
Only D seems to make sense.
upvoted 1 times
...
Jupi
3 years, 6 months ago
A - Incorrect This will be done by DMS by default. B - Incorrect - Conversion reports are by Schema Conversion tool C - Incorrect AWS DMS creates the replication instance on an Amazon EC2 instance. AWS DMS currently supports the T2, T3, C4, C5, R4, and R5 Amazon EC2 instance classes for replication instances: D - Correct. This will ensure migration is faster.
upvoted 1 times
...
Cotter
3 years, 7 months ago
OK the most sound is D.
upvoted 1 times
...
pablobairat
3 years, 7 months ago
D Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.General.SlowTask
upvoted 1 times
DerekKey
3 years, 6 months ago
This is a general source not Aurora MySQL specific: You can't disable automated backups on Aurora. The backup retention period for Aurora is managed by the DB cluster. D is WRONG
upvoted 1 times
...
...
mericov
3 years, 7 months ago
D - When migrating to an Amazon RDS database, it's a good idea to turn off backups and Multi-AZ on the target until you're ready to cut over. Similarly, when migrating to systems other than Amazon RDS, turning off any logging on the target until after cutover is usually a good idea. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
upvoted 1 times
DerekKey
3 years, 6 months ago
WRONG we have Aurora MySQL
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago