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%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Trinidad

1 months ago

Wait, so they want zero data loss but also want to do real application testing on the standby? Sounds like they're trying to have their cake and eat it too. Good luck with that!

upvoted 0 times

Carmela

16 days ago

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

upvoted 0 times

...

Ronny

1 months ago

Haha, 'These requirements cannot be met'? That's a bold move, Candidate A. I wonder if they're just trying to be funny or if they actually think it's impossible.

upvoted 0 times

Kimberely

18 days ago

A: I think option B could work for this requirement.

upvoted 0 times

...

Michael

2 months ago

I don't know, Option D looks pretty interesting too. A far sync instance plus a snapshot standby sounds like it could provide the flexibility they're looking for.

upvoted 0 times

Lanie

17 days ago

Option D might be too complex for their needs. Option B or C would be more straightforward.

upvoted 0 times

...

Fabiola

26 days ago

I think Option C could also work since it allows for real time query on the standby database.

upvoted 0 times

...

Armanda

1 months ago

I agree, Option B provides the necessary flexibility for their requirements.

upvoted 0 times

...

Merilyn

2 months ago

Option B seems like the best choice. It allows for real application testing on the standby database.

upvoted 0 times

...

Catherin

2 months ago

Option B seems like the best choice here. Synchronous redo transport ensures zero data loss, and the ability to convert to a snapshot standby for testing is a nice feature.

upvoted 0 times

Micaela

1 months ago

I agree, Option B covers all the requirements effectively. It's a good recommendation.

upvoted 0 times

...

Stephanie

2 months ago

Option B seems like the best choice here. Synchronous redo transport ensures zero data loss, and the ability to convert to a snapshot standby for testing is a nice feature.

upvoted 0 times

...