ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 302 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 302
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is planning to migrate a 40 TB Oracle database to an Amazon Aurora PostgreSQL DB cluster by using a single AWS Database Migration Service (AWS DMS) task within a single replication instance. During early testing, AWS DMS is not scaling to the company's needs. Full load and change data capture (CDC) are taking days to complete.

The source database server and the target DB cluster have enough network bandwidth and CPU bandwidth for the additional workload. The replication instance has enough resources to support the replication. A database specialist needs to improve database performance, reduce data migration time, and create multiple DMS tasks.

Which combination of changes will meet these requirements? (Choose two.)

  • A. Increase the value of the ParallelLoadThreads parameter in the DMS task settings for the tables.
  • B. Use a smaller set of tables with each DMS task. Set the MaxFullLoadSubTasks parameter to a higher value.
  • C. Use a smaller set of tables with each DMS task. Set the MaxFullLoadSubTasks parameter to a lower value.
  • D. Use parallel load with different data boundaries for larger tables.
  • E. Run the DMS tasks on a larger instance class. Increase local storage on the instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rdiaz at March 26, 2023, 5:52 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
roymunson
1 year, 7 months ago
Selected Answer: B
It's B&D: A - Not applicable for Oracle see:https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.TargetMetadata.html#:~:text=ParallelLoadThreads%20%E2%80%93%20Specifies%20the%20number%20of%20%20threads,Kafka%2C%20or%20Amazon%20Elasticsearch%20Service%20target%20is%2032. B - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.FullLoad.html D - https://aws.amazon.com/blogs/database/speed-up-database-migration-by-using-aws-dms-with-parallel-load-and-filter-options/
upvoted 3 times
...
Windy
1 year, 9 months ago
It's BD
upvoted 1 times
...
icttss
1 year, 11 months ago
How about A and B? What is the data boundary meaning of option D?
upvoted 1 times
...
tsk9921
1 year, 12 months ago
BD my vote. Please note Question is asking 2 answer choices...
upvoted 1 times
...
clarksu
2 years ago
Selected Answer: D
https://aws.amazon.com/blogs/database/speed-up-database-migration-by-using-aws-dms-with-parallel-load-and-filter-options/ B + D
upvoted 3 times
...
backbencher2022
2 years, 1 month ago
Selected Answer: B
B and D are correct options
upvoted 2 times
...
rdiaz
2 years, 1 month ago
Selected Answer: B
B and d https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.FullLoad.html
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago