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

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database falls.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

Answer options

• A. SYNC NOAFFRIM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Availability
• C. ASYNC and Maximum Performance
• D. SYNC AFFIRM and Maximum Availability
• E. SYNC AFFIRM and Maximum Protection

Correct answer: D

Explanation

The correct answer is D because 'SYNC AFFIRM and Maximum Availability' allows for automatic failover while maintaining high data protection. Option A, while providing maximum protection, does not support automatic role transition if the primary fails. Option B offers availability but does not ensure the highest level of protection. Option C prioritizes performance over protection, and option E, while protective, does not support automatic failover.