ExamPark
Course menuDEA-C01

Exams / DEA-C01 / Schema design, conversion and lineage / Question 1

DEA-C01 practice question: Schema design, conversion and lineage

Data Store Management A free question from our original DEA-C01 practice exam. Try it, then open the answer to see why each option is right or wrong.

Last verified against current AWS documentation ·How we write our questions

A healthcare-analytics company plans to migrate an Oracle data warehouse to Amazon Redshift. The schema has about 600 tables, 80 views and 150 stored procedures written in PL/SQL. Some views and procedures use Oracle-only functions.

The company must know which objects convert automatically, which need manual work, and how much effort the manual work will take, before it commits to a migration plan.

Which step should the team take first?

Choose one answer.

  1. A. Create an AWS DMS replication task with the full-load option, and run it to see which tables fail to load into Redshift.
  2. B. Run an AWS Glue crawler on the Oracle database, and review the tables it discovers in the Data Catalog for the conversion plan.
  3. C. Rewrite all 150 procedures in Python on AWS Lambda first, and then move the data with DMS once the procedures run correctly.
  4. D. Use AWS DMS Schema Conversion to assess the Oracle schema, convert what it can, and report the objects needing manual work.
Show the answer and explanation

Answer: D

  • A. Wrong: A DMS replication task moves rows, and it does not convert the schema objects such as procedures and views. The option reveals data load problems but not the conversion effort.
  • B. Wrong: A crawler reads table metadata into the catalog, but it does not analyze procedures or views for conversion. The option gives an incomplete picture of the work.
  • C. Wrong: Rewriting every procedure before knowing which ones convert automatically commits the team to the most effort before the assessment. The option skips the step that gives the plan its scope.
  • D. Right: Correct. DMS Schema Conversion assesses the source schema against the Redshift target and converts the objects it supports. Its assessment report lists the objects that need manual changes, which gives the team the effort estimate it needs. Learn more: Converting database schemas using DMS Schema Conversion (opens in a new tab)

Explanation

Before a heterogeneous migration, the team needs to know which schema objects convert automatically and how much manual work remains. DMS Schema Conversion assesses the Oracle schema against Redshift, converts what it can, and reports the objects that need manual changes. Replication, catalog crawling and early rewrites do not produce that assessment.

Study

Keep practicing

Answer questions with a score at the end, or practice just this topic with the explanation after each one. No sign-up needed.

Take the free DEA-C01 practice examPractice Schema design, conversion and lineageAll Schema design, conversion and lineage questions

Want more on Schema design, conversion and lineage? The 5 full-length practice sets have 6 more Schema design, conversion and lineage questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets