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:

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

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

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

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

Migrate the database to Amazon DynamoDB to improve transactional performance.

Use Amazon ElastiCache to offload the read queries.

How to approach this question

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

Full Answer

Use AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) with Change Data Capture (CDC) enabled., Provision an Amazon RDS for Oracle instance in a Multi-AZ deployment., Create an RDS Read Replica for the Oracle database to offload read queries.

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

Common mistakes

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

Question 26 All questions Question 28

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 7

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...Hard Q02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...Hard Q03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...Medium Q04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...Easy Q05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard

View all 75 questions →