exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 23 discussion

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

A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

  • A. EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: physt1, FASTSYNC); EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1 SYNC); EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES= (prima: physt2 SYNC); EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
  • B. EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1 ASYNC); EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES= (prima: physt FASTSYNC); EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
  • C. EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1 SYNC); EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES= (prima: physt ASYNC); EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
  • D. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: physt1, FASTSYNC)’; EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1, FASTSYNC)’; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt2 ASYNC)’;
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
The route between fs1 and physical standbase in the remote region, like physt2, should be SYNC or SYNC NOAFFIRM.
Note:
Fast Sync is a new Data Guard capability available with Oracle Database 12c. Fast Sync enables use of the destination parameter NOAFFIRM which specifies that the standby acknowledge receipt of redo without waiting for the write to the standby redo log file to complete. Fast Sync can improve application response time in a SYNC configuration by removing remote I/O from the total round trip time.
Active Data Guard Far Sync Architecture

Incorrect Answers:
B: There is no keyword FASTSYNC. To configure fast sync you use SYNC NOAFFIRM.
C: The route between fs1 and physical standbase in the remote region, like physt, should be SYNC, not ASYNC.
D: The route between fs1 and physical standbase in the remote region, like physt2, should be SYNC, not ASYNC.
References:
http://www.oracle.com/technetwork/database/availability/farsync-2267608.pdf

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
Rockfics
1 year, 3 months ago
Answer C. Is the only good combination about the use of Far Sync Instante. Local Far SYNC Instance with SYNC and Remote Standby with ASYNC over FAR SYNC with alternate with Primary DB
upvoted 1 times
...
JESUSBB
1 year, 9 months ago
Answer: D
upvoted 3 times
...
JorgeZG
1 year, 11 months ago
Anwer C
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago