ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-997-20 All Questions

View all questions & answers for the 1z0-997-20 exam
Go to Exam

Exam 1z0-997-20 topic 1 question 24 discussion

Actual exam question from Oracle's 1z0-997-20
Question #: 24
Topic #: 1
[All 1z0-997-20 Questions]

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.)

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by fhoyos at Nov. 18, 2020, 5:06 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fhoyos
Highly Voted 4 years, 5 months ago
B is the answer: RAC Database is not required in this solution. Standalone will be most suitable and cost effective. You can create the standby DB system in a different availability domain from the primary DB system for availability and disaster recovery purposes. With Data Guard and switchover/failover can meet RTO 1 hour.
upvoted 11 times
...
FPM
Most Recent 1 year, 12 months ago
Selected Answer: B
A. Hard to do a recovery in 1 hour (RTO) B. Data Guard is included in EE and you achieve RTO of 1 hour. You can achieve goals and is more cost-effective than with RAC. C. Makes no sense D. Is more expensive and you need Extreme Performance for RAC
upvoted 1 times
...
FPM
2 years ago
Why not A? It is even more cost effective? The only cons is if you are able to recover RMAN backup in 1 hour, but the size of the DB is not specified in the question.
upvoted 1 times
...
domingoshd
3 years, 1 month ago
Selected Answer: D
Similar at the
upvoted 1 times
...
BalaChinnasamy
3 years, 2 months ago
B should be the answer because of its acos effective solution. even though D is abtter solution for a larger company
upvoted 2 times
...
serivn
3 years, 2 months ago
B looks good, but please consider that this is a major client of this company, and the business continuity is critical, even in case of entirely region down, that rarely happen with the cloud computing. So that, a design for this kind of company and requirement is not just based on the cost aspect. A single node of database is quite risk even you can switch back and forth. A RAC solution is more resonable in this case, so D is the most applicable option. --> D is correct answer.
upvoted 1 times
...
gogune
3 years, 3 months ago
ATP cannot be source for goldengate to replicate,so C not right choice, B is right one
upvoted 2 times
...
davidliuatoracle
4 years, 3 months ago
Why not C?
upvoted 1 times
bilegt
4 years, 2 months ago
I think C is not very cheap to run comparing to A,B.
upvoted 1 times
...
...
ankit89
4 years, 4 months ago
B is correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago