Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 12

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend?

Answer options

• A. a remote physical standby database with RedoRoutes via a far sync instance
• B. a snapshot standby database with synchronous redo transport
• C. a physical standby database with real-time query enabled
• D. a logical standby database
• E. a read mostly implementation of a physical standby database

Correct answer: B, C

Explanation

The correct answers are B and C. A snapshot standby database with synchronous redo transport (B) allows for reporting while maintaining zero data loss, and a physical standby database with real-time query enabled (C) supports queries on the standby while ensuring data integrity. The other options either do not support the required reporting capabilities or do not guarantee zero data loss during a failover.