AWS Certified Data Engineer Associate DEA-C01 Practice Question
A company plans to migrate its 15-TB on-premises Oracle data warehouse to Amazon Redshift. The data warehouse contains hundreds of PL/SQL packages, functions, and triggers. Before starting the migration, the data engineering team must estimate how much of this database code can be converted automatically and how much will require manual rewriting. Which approach will provide the quickest and most accurate estimate?
Use an AWS Glue crawler to crawl the Oracle instance and inspect the generated metadata.
Run an assessment report in AWS Schema Conversion Tool against the Oracle schema.
Create an AWS Database Migration Service full-load task with schema conversion enabled and review the task logs.
Query the Oracle database from Amazon Redshift using federated queries to identify unsupported objects.
The AWS Schema Conversion Tool (AWS SCT) can connect to the Oracle source, scan database objects, and generate an assessment report that categorizes each object as fully, partially, or not convertible to Amazon Redshift. This report quantifies the automatic conversion percentage and lists items that need manual work, giving the team an immediate effort estimate. AWS DMS performs data movement but does not analyze procedural code. Redshift federated queries and AWS Glue crawlers expose or discover schemas but do not evaluate conversion complexity.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.