Which THREE are always benefits of using a logical standby database?
A.
It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
B.
It can be used for reporting workloads requiring additional indexes or materialized views or both.
C.
It can be used for testing patchsets without affecting the primary database.
D.
It can be used for database rolling release upgrades.
E.
It can be used to replicate a single pluggable database (PDB) in a multitenant container database.
F.
It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.
The Answer Is:
A, B, D
This question includes an explanation.
Explanation:
Logical standby databases are a key feature of Oracle Data Guard and offer several distinct advantages, especially in terms of flexibility for reporting, upgrades, and disaster recovery:
Disaster-recovery solution with switchover and failover options (A):Logical standby databases provide a robust disaster-recovery solution, ensuring that any data updated on the primary database can be recovered. They support both switchover and failover operations, allowing for smooth role transitions between the primary and standby databases.
Used for reporting workloads requiring additional indexes or materialized views (B):Logical standby databases can be opened for read-write operations and can have additional indexes or materialized views that are not present in the primary database. This makes them ideal for offloading reporting and querying workloads from the primary database.
[References:, Oracle Data Guard Concepts and Administration Guide, Oracle Database High Availability Overview, ]
1z0-076 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"