A company is migrating a critical Oracle database to Amazon RDS for Oracle. The database is 10 TB and supports a highly transactional application. The migration must have near-zero downtime. The company also wants to offload read queries to a separate database instance after migration. Which combination of steps should the architect take? (Select THREE)

Answer options:

A.

Use AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) with Change Data Capture (CDC) enabled.

B.

Take an offline backup of the Oracle database using RMAN and restore it to RDS.

C.

Provision an Amazon RDS for Oracle instance in a Multi-AZ deployment.

D.

Create an RDS Read Replica for the Oracle database to offload read queries.

E.

Migrate the database to Amazon DynamoDB to improve transactional performance.

F.

Use Amazon ElastiCache to offload the read queries.

How to approach this question

Select the tools for zero-downtime migration, HA, and read scaling.

DMS with CDC provides near-zero downtime migration. Multi-AZ ensures high availability. RDS Read Replicas allow read query offloading.

Thinking RDS for Oracle doesn't support Read Replicas (it does, via Active Data Guard).

75 questions · hints · full answers · grading