Exam 1z0-066 All QuestionsBrowse all questions from this exam
Go to Exam
Question 53

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:

1. Data loss is not permitted.

2. Read-only applications should not connect to the primary database instance.

Additionally, there are these requirements, only one of which is ever done at any one time:

1. It should be possible to apply designated patches with a minimum amount of downtime.

2. Upgrading to a new database release should be performed with the least possible amount of downtime.

3. New application software releases should be tested against an exact and up-to-date replica of the primary database.

Which configuration meets these requirements with the fewest databases?

    Correct Answer: E

    A primary database with two physical standby databases is the best configuration to meet all requirements with the fewest databases. Two standby databases can ensure no data loss (one can be in synchronous mode), permit read-only applications to connect without affecting the primary, and provide a way to test patches, upgrades, and new releases with minimal downtime. Having an exact and up-to-date replica ready ensures all operational needs and testing requirements necessitate only this configuration.

Discussion
RockficsOption: A

A. a primary database with three physical standby databases To avoid data lost => STB PHYSICAL 1 To Read Only Reports => STB PHYSICAL 2 To Upgrade, Testing, Patch => STB PHYSICAL 3