Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 54

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload 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:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

Answer options

Correct answer: C

Explanation

The correct answer is C because the proposed configuration of a primary database with one physical standby in Maximum Protection mode ensures that there is no data loss (requirement 1) and that read-only applications do not access the primary database instance (requirement 2). However, this setup does not address the other requirements regarding downtime for patches, upgrades, or testing new application software releases.