Question

Your expertise is requested for these customer requirements: The Data Guard environment must be in maximum protection mode. Reports must be offloaded to a physical standby database. There must be no lag between the primary and standby databases that affect the reports produced. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

Accepted Answer

Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

Answer

Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport

Answer

One physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected to the primary

Answer

One physical standby database with Real-Time Query enabled and STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

Answer

Two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

Your expertise is requested for these customer requirements: The Data Guard environment must be in maximum protection mode. Reports must be offloaded…

Take the free 1Z0-076 practice test

Other 1Z0-076 practice questions