Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A company will migrate its 10-TB on-premises Oracle data warehouse to Amazon Redshift. The data engineer wants an AWS tool to translate all tables, indexes, and views, resolve datatype differences, and automatically create the converted objects in the Redshift cluster without writing any DDL by hand. Which approach satisfies these requirements?

  • Generate an AWS SCT assessment report, then manually create the Redshift DDL statements identified in the report.

  • Use AWS SCT data extraction agents to unload Oracle data to Amazon S3 and import the files with the Redshift COPY command, letting Redshift create tables automatically.

  • Create an AWS Database Migration Service full-load task with Oracle as source and Redshift as target so DMS converts and applies all schema objects automatically.

  • Run AWS Schema Conversion Tool in online mode, connect to Oracle and Amazon Redshift, perform schema conversion, and choose Apply to database to deploy the converted objects.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot