CLF-C02 - Cloud Technology and Services (34% of the exam) - Section 3.7
Identify AWS database migration tooling, including the AWS Database Migration Service and the AWS Schema Conversion Tool.
Describe the AWS Database Migration Service as the tool for migrating databases with minimal downtime, and distinguish homogeneous migrations, where the source and target engine match, from heterogeneous ones that need conversion. Recognise the AWS Schema Conversion Tool as the companion that translates schema and code between incompatible engines.
lock_openFree sampleCloud Technology and Serviceseasy
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 migrationcheck_circle Correct
AWS Schema Conversion Tool converts a source schema and code to suit a different target database engine. Moving between different engines means the schema and procedural code may not be compatible, and AWS SCT translates those objects to the target engine so the database works once the data is migrated.
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.
Answers that look right on this material and are not. Each one is a distractor from a different question in the CLF-C02 bank for this domain.
Amazon RDS, which is a managed relational database service that hosts the engine for you but is not the tool that performs the move from on-premises
errorWhy it is wrong: Amazon RDS can be the destination for the data, but it runs databases rather than performing the migration itself, so it is not the service that moves the data across.
A heterogeneous migration, because the source and target use the same database engine, so the schema must first be converted to a different engine
errorWhy it is wrong: Heterogeneous describes a move between different engines, so it does not fit a MySQL to MySQL migration where the engine stays the same.
The source database must be shut down for the whole migration, so customers cannot use the application until all of the data has finished moving across
errorWhy it is wrong: Requiring the source to be offline throughout would cause long downtime, which is the opposite of what AWS DMS is designed to avoid.