Exam AWS Certified Database - Specialty topic 1 question 165 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 165
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is planning on migrating a 500-GB database from Oracle to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and
AWS DMS. The database does not have any stored procedures to migrate but has some tables that are large or partitioned. The application is critical for business so a migration with minimal downtime is preferred.
Which combination of steps should a database specialist take to accelerate the migration process? (Choose three.)

A. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.
B. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.
C. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.
D. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.
E. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
F. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Show Suggested Answer

Suggested Answer: DE 🗳️

by hemantr at Nov. 14, 2021, 2:12 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

Submit Cancel

novice_expert

Highly Voted 3 years, 1 month ago

Selected Answer: DE

C, D, E ( does not allow to select 3 options) E. use SCT to convert schema -> C. Create a table setting rule with parallel load option, load using DMS -> D. Continue DMS till cutover date

upvoted 8 times

...

lollyj

Most Recent 2 years, 5 months ago

Selected Answer: CD

CDE are the answers

upvoted 3 times

...

jjyy80

2 years, 5 months ago

DE is the correct

upvoted 1 times

...

examineme

2 years, 6 months ago

Selected Answer: CE

CDE correct answer

upvoted 2 times

...

RotterDam

3 years, 3 months ago

D and E are obviously correct. Between B and C -> C is correct - the aws recommendation is to load Large tables via partitioning. That means creating filters to load data in parallel. The rest of the smaller tables can use the MaxFullLoadSubTasks settings to a higher value (default is 8) An example is if you have a schema that contains 90 tables, 1 of which is 100GB while rest are small tables Create multiple tasks that break up the 100GB based on primary key Create another task to load the smaller tables with "MaxFullLoadSubtasks" settings to 20

upvoted 3 times

...

tugboat

3 years, 3 months ago

Selected Answer: DE

CDE are valid options

upvoted 1 times

...

awsmonster

3 years, 4 months ago

I vote for CDE

upvoted 1 times

...

Shunpin

3 years, 5 months ago

I prefer CDE For option C, https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Tablesettings.html#CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Tablesettings.ParallelLoad

upvoted 3 times

...