Oracle Exam 1Z0-076 Topic 2 Question 15 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 15
Topic #: 2

[All 1Z0-076 Questions]

A customer asks for your recommendation regarding this requirement:

1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.

2. We want zero data loss in case of a disaster involving the loss of one component.

3. We want to do Real Application Testing occasionally on the Standby Database.

Which solution, if any, satisfies these requirements?

AThese requirements cannot be met.

BA physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

CA snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

DA far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

Show Suggested Answer

Suggested Answer: B, D, E

After a successful failover to the 'cats' database in a Data Guard configuration:

B: Sheep, being another standby database, would typically remain in the enabled state unless specifically disabled or if there was a configuration issue.

D: Dogs, which was the primary database prior to failover, will be in a disabled state as part of the failover process. Manual intervention is required to re-establish 'dogs' as a standby database or to return it to the primary role through another role transition.

E: If the configuration was in Maximum Availability mode before failover, it would remain in this mode after failover, provided all settings were properly configured and no changes were made to the protection mode.

Option A is incorrect because failover does not automatically change the protection mode to Maximum Performance. The protection mode remains as it was prior to the failover unless manually altered.

by Kiley at Jul 18, 2024, 10:53 PM

Limited Time Offer

25%

28 days ago

I think option B could work for this requirement.

upvoted 0 times

...