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?
A.
2, 3, 4, and 5
B.
1, 2, 3, 4, and 5
C.
1 and 2
D.
only requirement 5
E.
only requirement 1
Explanation:
Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
Because this data protection mode prioritizes data protection over primary database availability, Oracle
recommends that a minimum of two standby databases be used to protect a primary database that runs in
maximum protection mode to prevent a single standby database failure from causing the primary database to
shut down.
Incorrect Answers:
A, D: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
1,2
For MaxProtection recommendation is two standby databases. In this case I believe you can meet 1 & 2
Ans: C. 1 and 2
https://docs.oracle.com/database/121/SBYDB/protection.htm#SBYDB02000
C