AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 32
A company plans to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. They need to ensure a seamless migration of both the database schema and the data with minimal downtime. The company also requires a tool to convert the source database schema to be compatible with Amazon Aurora PostgreSQL.
Which combination of AWS services should the company use to migrate the database schema and data?
-
A
Utilize Amazon RDS for data migration and AWS Lambda for schema conversion.
-
B
Apply Amazon S3 transfer acceleration for data migration and Amazon Athena for schema conversion.
-
C
Implement AWS Glue for both schema conversion and data migration.
-
D
Use AWS Database Migration Service (DMS) for data migration and AWS Schema Conversion Tool (SCT) for schema conversion.
Reveal correct answer
Correct answer: D
Explanation
AWS DMS is an ideal service for migrating databases with minimal downtime. It supports various source and target databases, including Oracle and Amazon Aurora PostgreSQL. AWS DMS efficiently migrates data from the existing database to the target database on AWS.
For the schema conversion, the AWS Schema Conversion Tool (SCT) helps convert the source database schema to be compatible with the target database, in this case, Amazon Aurora PostgreSQL. SCT assesses the source database, automatically converts the schema to the target format, and highlights any elements that require manual conversion, ensuring a comprehensive migration process.
CORRECT: "Use AWS Database Migration Service (DMS) for data migration and AWS Schema Conversion Tool (SCT) for schema conversion" is the correct answer (as explained above.)
INCORRECT: "Implement AWS Glue for both schema conversion and data migration" is incorrect.
AWS Glue is primarily an ETL (extract, transform, load) service used for preparing and transforming data for analytics. It is not specifically designed for database schema conversion or for complex data migrations like DMS and SCT.
INCORRECT: "Utilize Amazon RDS for data migration and AWS Lambda for schema conversion" is incorrect.
Amazon RDS is a database service for operation and management of databases, not for migrating data between different database platforms. AWS Lambda is a serverless computing service and is not suitable for database schema conversion tasks.
INCORRECT: "Apply Amazon S3 transfer acceleration for data migration and Amazon Athena for schema conversion" is incorrect.
Amazon S3 transfer acceleration is intended to speed up the transfer of files to S3, not for database migrations. Amazon Athena is a query service used to analyze data in Amazon S3 using SQL and is not designed for schema conversion or database migrations.
References:
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_DMSIntegration.html
Save time with our AWS cheat sheets:
https://digitalcloud.training/aws-certified-data-engineer-associate-cheat-sheet/
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
