ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam
Go to Exam

Exam 1z0-066 topic 1 question 10 discussion

Actual exam question from Oracle's 1z0-066
Question #: 10
Topic #: 1
[All 1z0-066 Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database.
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.
Incorrect Answers:
B: When a transport is performed using SYNC/NOAFFIRM, the primary performs write operations and waits only for acknowledgement that the data has been received on the standby, not that it has been written to disk. The SYNC/NOAFFIRM transport can provide a performance benefit at the expense of potential exposure to data loss in a special case of multiple simultaneous failures.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
by marpayer at May 4, 2021, 2:47 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
hilaire
1 year, 2 months ago
E is correct because there are three Standby Database .
upvoted 1 times
...
ScottL
1 year, 3 months ago
Selected Answer: 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
upvoted 1 times
...
JorgeZG
1 year, 11 months ago
For 19c, it could be E
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: D
upvoted 1 times
...
Sugar
3 years, 3 months ago
yes because there is not much change between version 11 and 12
upvoted 1 times
...
marpayer
3 years, 9 months ago
The referenced documment is for Oracle 11, this exam is for version 12
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago