Q: 16
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?
Options
Discussion
Probably A. Saw something like this on a practice exam, two standbys with real-time query covers both resilience and zero lag requirements.
Likely it's A. The two standby setup covers for single network failure and keeps max protection with zero lag reporting.
D , feels like that's the safest for lag but it's actually a trap because one network link failure would break maximum protection.
A
A imo since "maximum protection" means you need synchronous transport and zero data loss, plus two standbys gives network resilience. Real-Time Query with STANDBY_MAX_DATA_DELAY=0 meets the reporting and no lag needs. Let me know if anyone thinks differently.
Be respectful. No spam.
