Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 57 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 57
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

A. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
B. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
C. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
D. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster. Create a migration assessment report to evaluate the migration compatibility.

Show Suggested Answer

Suggested Answer: D 🗳️

by jnassp1 at July 27, 2020, 11:09 a.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

LMax

Highly Voted 3 years, 7 months ago

Must be D

upvoted 9 times

...

adelcold

Most Recent 1 year, 11 months ago

Selected Answer: D

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-from-ibm-db2-on-amazon-ec2-to-aurora-postgresql-compatible-using-aws-dms-and-aws-sct.html

upvoted 2 times

...

novice_expert

3 years, 1 month ago

Selected Answer: D

run AWS SCT from the Db2 database to an Aurora DB cluster. -> Create a migration assessment report to evaluate the migration compatibility.

upvoted 2 times

...

tugboat

3 years, 3 months ago

Selected Answer: D

SCT can do the required checks

upvoted 4 times

...

myutran

3 years, 7 months ago

Ans: D

upvoted 2 times

...

JobinAkaJoe

3 years, 7 months ago

D - right answer

upvoted 1 times

...

firbhat

3 years, 7 months ago

ANS: D • Converts DB/DW schema from source to target (including procedures / views / secondary indexes / FK and constraints) • Mainly for heterogeneous DB migrations and DW migrations

upvoted 3 times

...

jnassp1

3 years, 8 months ago

D - SCT

upvoted 2 times

...