DBS-C01 · Question #76
DBS-C01 Question #76: Real Exam Question with Answer & Explanation
The correct answer is D: Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB. https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/Schema-Conversion- · Converts DB/DW schema from source to target (including procedures / views / secondary indexes / FK and constraints) · Mainly for heterogeneous DB migrations and DW migrations
Question
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?
Options
- APerform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the
- BRun AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and
- CRun native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to
- DRun the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB
Explanation
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/Schema-Conversion- · Converts DB/DW schema from source to target (including procedures / views / secondary indexes / FK and constraints) · Mainly for heterogeneous DB migrations and DW migrations
Topics
Community Discussion
No community discussion yet for this question.