exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

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

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

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 🗳️

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
tgv
Highly Voted 3 years, 2 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, 1 month 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, 1 month 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 1 year, 11 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 1 times
...
bobsmith2000
2 years, 6 months ago
It seems like the answers don't match the question or there are some typos or mistakes
upvoted 2 times
...
Kuang
2 years, 9 months ago
B is my answer
upvoted 1 times
...
Bigbearcn
2 years, 10 months ago
Selected Answer: D
It's D.
upvoted 1 times
...
cldy
2 years, 12 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
...
AzureDP900
2 years, 12 months ago
B is right
upvoted 1 times
...
acloudguru
3 years 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, 1 month ago
It's B
upvoted 1 times
...
Kopa
3 years, 1 month ago
I will go for B
upvoted 1 times
...
tgv
3 years, 2 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, 1 month 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, 1 month 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, 2 months ago
Only D seems to make sense.
upvoted 1 times
...
Jupi
3 years, 2 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, 2 months ago
OK the most sound is D.
upvoted 1 times
...
pablobairat
3 years, 2 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, 1 month 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, 2 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, 1 month ago
WRONG we have Aurora MySQL
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
Loading ...