Exam 1z0-066 topic 1 question 83 discussion

Actual exam question from Oracle's 1z0-066

Question #: 83
Topic #: 1

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

A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
B. 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
C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC

Show Suggested Answer

Suggested Answer: B 🗳️
If STANDBY_MAX_DATA_DELAY is set to 0, a query issued to a physical standby database is guaranteed to return the exact same result as if the query were issued on the primary database, unless the standby database is lagging behind the primary database, in which case an ORA-3172 error is returned.
Real-time Query Restrictions include:
The standby database must receive redo data via the SYNC transport.
Note: In an Active Data Guard environment, this session parameter can be used to specify a session-specific apply lag tolerance, measured in seconds, for queries issued by non-administrative users to a physical standby database that is in real-time query mode.
Incorrect Answers:
C, D: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down.
E: Should use STANDBY_MAX_DATA_DELAY parameter set to zero.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm https://chenguangblog.wordpress.com/tag/standby_max_data_delay/

by oraexam12 at Sept. 13, 2022, 5:36 p.m.

Comments

Submit Cancel

Rockfics

1 year, 3 months ago

Selected Answer: D

Answer D. With one standby with REAL-TIME Query in Maximum Availability (SYNC ) is possible to keep NO DATA LOST without affect primary in network failure and attend reports offload updated like Primary with STANDBY_MAX_DATA_DELAY=0

upvoted 1 times

...

JESUSBB

1 year, 9 months ago

Answer: B

upvoted 1 times

...

oraexam12

2 years, 4 months ago

I am confused as the parameter STANDBY_MAX_DATA_DELAY session specific..........

upvoted 1 times

...

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 83 discussion

Comments

Rockfics

JESUSBB

oraexam12

SY0-701