Bird
0
0

You want to migrate an on-premises Oracle database to AWS RDS. Which RDS engine should you choose to ensure compatibility and minimal changes?

hard📝 Best Practice Q15 of 15
AWS - RDS and Relational Databases
You want to migrate an on-premises Oracle database to AWS RDS. Which RDS engine should you choose to ensure compatibility and minimal changes?
AOracle
BPostgreSQL
CAurora MySQL
DSQL Server
Step-by-Step Solution
Solution:
  1. Step 1: Identify the source database engine

    The source is an on-premises Oracle database, so compatibility is key.
  2. Step 2: Choose the matching RDS engine

    AWS RDS supports Oracle as a managed engine, which ensures compatibility and minimal changes during migration.
  3. Step 3: Consider other options

    Aurora MySQL, PostgreSQL, and SQL Server are different engines and would require significant changes.
  4. Final Answer:

    Oracle -> Option A
  5. Quick Check:

    Match source engine to RDS engine for smooth migration [OK]
Quick Trick: Pick the same engine type for easy migration [OK]
Common Mistakes:
MISTAKES
  • Choosing Aurora MySQL for Oracle migration
  • Assuming PostgreSQL is compatible with Oracle
  • Ignoring migration compatibility

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More AWS Quizzes