You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these requirements?
A.
SYNC AFFIRM and Maximum Protection
B.
SYNC NOAFFIRM and Maximum Protection
C.
SYNC AFFIRM and Maximum Availability
D.
SYNC NOAFFIRM and Maximum Availability
E.
ASYNC and Maximum Performance
Hi
I agree with C
https://docs.oracle.com/database/121/SBYDB/protection.htm#SBYDB4744
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log.
C
C is correct !