A company is moving from a commercial Oracle database to Amazon Aurora, which uses a different database engine, and needs the tables, views, and stored procedures rewritten to suit the new engine before the data is migrated. Which AWS tool is designed for this conversion?
- AAmazon CloudWatch, which collects metrics and logs so teams can monitor their resources but does not convert a database schema to a different engine
- BAWS Config, which records how resources are set up and tracks changes for compliance but does not convert database schemas between engines
- CAmazon Athena, which runs queries directly over data held in Amazon S3 but does not convert a database schema for a different engine
- DAWS Schema Conversion Tool, which converts a source database schema and code so it works on a different target database engine before migration Correct
Why A is wrong: Amazon CloudWatch handles monitoring and alerting, so it has no role in rewriting a schema for a different database engine.
Why B is wrong: AWS Config tracks resource configuration over time, so it cannot convert tables and stored procedures for a new engine.
Why C is wrong: Amazon Athena queries data in place in Amazon S3, so it does not rewrite a schema to suit a different database engine.
Why D is correct: AWS SCT converts the schema and code objects so they fit the target engine, which is exactly what an Oracle to Aurora move needs before the data migration.