exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 457 discussion

A company is migrating a large, mission-critical database to AWS. A solutions architect has decided to use an Amazon RDS for MySQL Multi-AZ DB instance that is deployed with 80,000 Provisioned IOPS for storage. The solutions architect is using AWS Database Migration Service (AWS DMS) to perform the data migration. The migration is taking longer than expected, and the company wants to speed up the process. The company's network team has ruled out bandwidth as a limiting factor.
Which actions should the solutions architect take to speed up the migration? (Choose two.)

  • A. Disable Multi-AZ on the target DB instance.
  • B. Create a new DMS instance that has a larger instance size.
  • C. Turn off logging on the target DB instance until the initial load is complete.
  • D. Restart the DMS task on a new DMS instance with transfer acceleration enabled.
  • E. Change the storage type on the target DB instance to Amazon Elastic Block Store (Amazon EBS) General Purpose SSD (gp2).
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
lovelyone
Highly Voted 3 years, 8 months ago
The answer is : A&C Turn off backups and transaction logging 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 According to C - there is no service name DMS instance with transfer acceleration enabled
upvoted 26 times
DS01
3 years, 7 months ago
But its mentioned, "when migrating to systems other than Amazon RDS, turning off any logging on the target until after cutover is usually a good idea"
upvoted 3 times
...
...
primanturin
Highly Voted 3 years, 8 months ago
I believe the answers should be: A and C Why A and C? Turn off backups and transaction logging 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#CHAP_BestPractices.Performance Why not B? The questions establishes that "A solutions architect has decided to use an Amazon RDS for MySQL Multi-AZ DB instance that is deployed with 80,000 Provisioned IOPS for storage" Checking the AWS DMS replication instance for migration available from this link: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html#CHAP_ReplicationInstance.Types.Deciding we can take dms.r5.24xlarge which can we give us a maximum of 80,000 IOPS based on this other link: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-optimized.html
upvoted 15 times
...
cloud_collector
Most Recent 2 years, 9 months ago
Selected Answer: AC
You can increase the speed of an initial migration load by doing the following: If your target is an Amazon RDS DB instance, make sure that Multi-AZ isn't enabled for the target DB instance. Turn off any automatic backups or logging on the target database during the load, and turn back on those features after your migration is complete. If the feature is available on your target, use provisioned IOPS. If your migration data contains LOBs, make sure that the task is optimized for LOB migration. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.General.SlowTask
upvoted 1 times
cloud_collector
2 years, 9 months ago
B is not correct , In the quesiton mentioned , "utilize an Amazon RDS for MySQL Multi-AZ DB instance with storage capacity of 80,000 Provisioned IOPS", The Range of Provisioned IOPS of MySQL, is "1,000–80,000 IOPS", 80,000 is maximum, so cannot has a larger IOPS than it https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#USER_PIOPS
upvoted 1 times
...
...
asiansensation
2 years, 10 months ago
Answer is A and C You can increase the speed of an initial migration load by doing the following: If your target is an Amazon RDS DB instance, make sure that Multi-AZ isn't enabled for the target DB instance. Turn off any automatic backups or logging on the target database during the load, and turn back on those features after your migration is complete. If the feature is available on your target, use provisioned IOPS. If your migration data contains LOBs, make sure that the task is optimized for LOB migration. For more information on optimizing for LOBs, see Target metadata task settings.
upvoted 1 times
...
naveenagurjara
2 years, 11 months ago
Selected Answer: AC
A and C
upvoted 1 times
...
FF11
3 years, 5 months ago
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.General.SlowTask
upvoted 1 times
...
FF11
3 years, 5 months ago
A&C are correct
upvoted 1 times
...
EmeraldTech
3 years, 5 months ago
Answer is A, C Turn off backups and transaction logging 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.
upvoted 1 times
EmeraldTech
3 years, 5 months ago
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
upvoted 1 times
...
...
muhsin
3 years, 5 months ago
A and D for A https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#:~:text=When%20migrating%20to%20an%20Amazon%20RDS%20database%2C%20it%27s%20a%20good%20idea%20to%20turn%20off%20backups%20and%20Multi-AZ%20on%20the%20target%20until%20you%27re%20ready%20to%20cut%20over. for D https://aws.amazon.com/solutions/databasemigrations/database-migration-accelerator/ not C because it is valid if the target is not RDS.
upvoted 3 times
...
muhsin
3 years, 5 months ago
the concern is bandwidth so A is not the answer. Multi-AZ load happens between database nodes not on-premises to Cloud. C, D
upvoted 1 times
...
Sumit_Kumar
3 years, 5 months ago
Selected Answer: AC
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html
upvoted 1 times
...
jc966
3 years, 6 months ago
AB https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
upvoted 1 times
...
ja_girl_eng
3 years, 6 months ago
A & C: "When migrating to Amazon RDS Instance, it is recommended to disable Backups and Transaction Logging onto Target data store until you are ready to cut over. Similarly, when migrating to non-Amazon RDS systems, disabling any logging on the target until after cut over is usually a good idea." https://www.linkedin.com/pulse/migrate-on-premises-rds-instance-amazon-using-data-bindlish-pmp-
upvoted 1 times
...
jc966
3 years, 6 months ago
AB A number of factors affect the performance of your AWS DMS migration: Resource availability on the source. The available network throughput. The resource capacity of the replication server. The ability of the target to ingest changes. The type and distribution of source data. The number of objects to be migrated.
upvoted 2 times
...
Jonfernz
3 years, 7 months ago
Definitely 100% A&B. A is confirmed: With Amazon RDS databases, it's a good idea to turn off backups and Multi-AZ until the cutover. C is definitely out: While migrating to non-RDS systems, it's a good idea turn off any logging on the target until the cutover. (not a good idea to do this for RDS) https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.ReducingLoad B is definitely the other solution. I've already checked it on the console. DMS uses ec2 instances --- you can choose how powerful you want them to be. So yeah : A&B. Final answer. No doubt.
upvoted 8 times
gargaditya
3 years, 6 months ago
Completely agree.
upvoted 1 times
...
...
tcpphoenix
3 years, 7 months ago
A and B is correct https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.Performance
upvoted 4 times
swadeey
3 years, 7 months ago
C is definitely correct. Even common sense. Which is other is the question
upvoted 1 times
...
...
Radeeka
3 years, 7 months ago
Bandwidth utilization is the bottleneck here so we need to choose the action that will reduce the BW utilization. A - Would reduce the amount of data need to be transfered D - Would reduce the time the data takes to transfer
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 ...