Exam 1z0-066 All QuestionsBrowse all questions from this exam
Question 10

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?

    Correct Answer: D

    The chosen configuration should provide high data protection without compromising availability. SYNC AFFIRM transport mode ensures that the primary database waits for acknowledgment from the standby database indicating that redo data has been written to disk. Maximum Availability mode combines this with automatic failover capabilities, ensuring that the standby database can automatically become the primary database in case of failure without risking the availability of the primary database. Therefore, SYNC AFFIRM and Maximum Availability provide the required balance between data protection and system availability.

Discussion
hilaireOption: E

E is correct because there are three Standby Database .

ScottLOption: E

Requirement specifies highest level of protection, and fast-start failover configured. You can enable fast-start failover when the configuration is in maximum protection, maximum availability mode, or maximum performance mode. Therefore, E

JorgeZGOption: E

For 19c, it could be E

JESUSBBOption: D

Answer: D

Sugar

yes because there is not much change between version 11 and 12

marpayer

The referenced documment is for Oracle 11, this exam is for version 12