Oracle Cloud Infrastructure 2020 Architect Professional — Question 31

An automobile company wants to deploy their CRM application for Oracle Database on Oracle Cloud Infrastructure (OCI) DB Systems for one of its major clients.
In compliance with the business continuity program of the client, they need to provide a Recovery Point Objective (RPO) of 24 hours and a Recovery Time
Objective (RTO) of 1 hour. The CRM application should be available even in the event that an entire OCI Region is down.
Which approach meets these requirements in the most cost effective manner? (Choose the best answer.)

Answer options

• A. Deploy a 1 node VM Oracle database in one region. Manually Configure a Recovery Manager (RMAN) database backup schedule to take hourly database backups. Asynchronously copy the database backups to object storage in another OCI region. If the primary OCI region is unavailable, launch a new 1 node VM Database in the other OCI region and restore the production database from the backup.
• B. Deploy a 1 node VM Oracle database in one region and replicate the database to a 1 node VM Oracle database in another region using a manual setup and configuration of Oracle Data Guard.
• C. Deploy an Autonomous Transaction Processing database in one region and replicate it to an Autonomous Transaction Processing database in another region using Oracle GoldenGate.
• D. Deploy a 2 node Virtual Machine (VM) Oracle RAC database in one region and replicate the database to a 2 node VM Oracle RAC database in another region using a manual setup and configuration of Oracle Data Guard.

Correct answer: B

Explanation

Option B is the correct choice because it allows for database replication across regions using Oracle Data Guard, ensuring both RPO and RTO requirements are met efficiently. Option A does not provide an adequate RTO since it relies on manual restoration, while Options C and D involve more complex configurations and potentially higher costs without significant advantages for this scenario.