Q: 11
Which four requirements can be met by deploying a logical standby database?
Options
Discussion
A C, E, F tbh. D is a trap since switchover/failover is more of a physical standby thing.
Probably D. Logical standby can definitely be used for DR with switchover and failover, so I’d include that requirement.
Actually, B isn't needed for a logical standby. It doesn't require the exact same physical structure as the primary. Instead, options A, C, E, and F fit better since logical standbys allow creating extra tables/indexes and support materialized views and Real Application Testing. Pretty sure these are right but open to corrections if I missed something!
Saw something very close to this on a practice set, pretty sure it's B.
Be respectful. No spam.