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
API Gateway - REST API creation - Quiz 9hard AWS Lambda - Environment variables in Lambda - Quiz 11easy AWS Lambda - Lambda concurrency and throttling - Quiz 12easy AWS Lambda - Lambda execution model - Quiz 9hard DynamoDB - Time to live (TTL) for expiration - Quiz 1easy Elastic Load Balancing - Target groups concept - Quiz 5medium Elastic Load Balancing - Target groups concept - Quiz 3easy RDS and Relational Databases - Read replicas for performance - Quiz 15hard SNS and SQS - SQS queue concept - Quiz 5medium SNS and SQS - SNS and SQS integration pattern (fan-out) - Quiz 4medium