1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ22

Oracle Data Guard Overview

You must recommend an Oracle Data Guard configuration for a database that supports a DSS workload and meets these permanent requirements:

  1. The performance effect on the primary database must be minimized.
  2. The creation and maintenance of materialized views must not affect primary-database performance.

Additionally, the following requirements exist, with only one ever performed at a time:

  1. Designated patches must be applicable with minimal downtime.
  2. An upgrade to a new database release must be performed with the least possible downtime.
  3. New application software releases must be tested against an exact, up-to-date replica of the production database.

You propose a configuration in Maximum Performance mode that has a primary database and one logical standby database.

Which requirements are met?

  • A 1 and 5
  • B 2 and 5
  • C 1, 2, and 3
  • D 1, 2, 3, 4, and 5
  • E 1, 2, and 4
  • F 2, 3, and 5
Explanation

Maximum Performance mode minimizes primary-database impact by using asynchronous redo transport. A logical standby can create and maintain local materialized views, offloading that work from the primary, and SQL Apply supports rolling upgrades to a new database release with minimal downtime. Certified Standby-First patches require a physical standby using Redo Apply, while exact production-replica testing in a read-write standby is provided by a snapshot physical standby, not a logical standby.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!