AWS Certified Data Engineer Associate DEA-C01 Practice Question
A company is migrating an on-premises Oracle data warehouse to Amazon Redshift. You will use AWS Schema Conversion Tool (AWS SCT) to convert the schema and SQL code. Which Oracle database element will AWS SCT convert automatically to a compatible Amazon Redshift object with no manual rewriting required?
AWS Schema Conversion Tool can automatically translate most structural objects, including tables and their column definitions, from Oracle to Amazon Redshift. When SCT encounters procedural code such as PL/SQL stored procedures, Oracle sequences, or materialized-view refresh logic, it flags them as action items that require manual conversion because equivalent functionality is not natively supported in Redshift.
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.